Collections:
Process Query Result in PL/SQL in Oracle
How To Process Query Result in PL/SQL in Oracle?
✍: FYIcenter.com
You can run queries (SELECT statements) in a PL/SQL code blocks, and process the results a loop as shown in the following script example:
SQL> set serveroutput on; SQL> BEGIN 2 FOR row IN 3 (SELECT * FROM employees WHERE manager_id = 101) 4 LOOP 5 DBMS_OUTPUT.PUT_LINE('Name = ' || row.last_name); 6 END LOOP; 7 END; 8 / Name = Greenberg Name = Whalen Name = Mavris Name = Baer Name = Higgins
The loop statement in this script automatically sets a temporary variable "row" each row in the result set returned from the SELECT statement.
⇒ Create an Array in PL/SQL in Oracle
⇐ Use SQL Statements in PL/SQL in Oracle
2019-03-08, 1557🔥, 0💬
Popular Posts:
How To Find Out What Privileges a User Currently Has in Oracle? Privileges granted to users are list...
How To Format Time Zone in +/-hh:mm Format in SQL Server Transact-SQL? From the previous tutorial, y...
What Happens to Your Transactions When ERROR 1213 Occurred in MySQL? If your transaction receives th...
What Is ISAM in MySQL? ISAM (Indexed Sequential Access Method) was developed by IBM to store and ret...
How to download and install the scaled-down database AdventureWorksLT in SQL Server? If you want to ...