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, 1653🔥, 0💬
Popular Posts:
Where to find answers to frequently asked questions on Managing Security, Login and User in SQL Serv...
Where to find answers to frequently asked questions on INSERT, UPDATE and DELETE Statements in MySQL...
How To Create a Stored Program Unit in Oracle? If you want to create a stored program unit, you can ...
What Happens If the UPDATE Subquery Returns Multiple Rows in MySQL? If a subquery is used in a UPDAT...
How to run Queries with SQL Server Management Studio Express in SQL Server? 1. Launch and connect SQ...