Collections:
Use SQL Statements in PL/SQL in Oracle
How To Use SQL Statements in PL/SQL in Oracle?
✍: FYIcenter.com
SQL DML (Data Manipulation Language) statements can be included in PL/SQL code blocks directly without any changes. See the script below for examples:
SQL> CREATE TABLE tip (id NUMBER(5) PRIMARY KEY, 2 subject VARCHAR(80) NOT NULL, 3 description VARCHAR(256) NOT NULL); Table created. SQL> BEGIN 2 INSERT INTO tip VALUES(1, 'PL/SQL', 3 'Good for beginners.'); 4 UPDATE tip SET description = 'Good for beginners.'; 5 END; 6 / PL/SQL procedure successfully completed. SQL> COL subject FORMAT A12; SQL> COL description FORMAT A24; SQL> SELECT * FROM tip; ID SUBJECT DESCRIPTION ---------- ------------ ------------------- 1 PL/SQL Good for beginners. SQL> DROP TABLE tip; Table dropped.
This script example actually has 3 parts:
⇒ Process Query Result in PL/SQL in Oracle
⇐ Execution Flow Control Statements in Oracle
2019-03-08, 1655🔥, 0💬
Popular Posts:
What are DDL (Data Definition Language) statements for tables in SQL Server? DDL (Data Definition La...
What Is a Dynamic Performance View in Oracle? Oracle contains a set of underlying views that are mai...
What Are Date and Time Functions in MySQL? MySQL offers a number of functions for date and time valu...
How To Query Tables and Loop through the Returning Rows in MySQL? The best way to query tables and l...
What Happens If the Imported Table Already Exists in Oracle? If the import process tries to import a...