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, 1556🔥, 0💬
Popular Posts:
How To End a Stored Procedure Properly in SQL Server Transact-SQL? Where the end of the "CREATE PROC...
How To Turn on mysql Extension on the PHP Engine in MySQL? The "mysql" API extension is provided as ...
What Is ISAM in MySQL? ISAM (Indexed Sequential Access Method) was developed by IBM to store and ret...
What Are Bitwise Operations in SQL Server Transact-SQL? Bitwise operations are binary operations per...
Can Date and Time Values Be Converted into Integers in SQL Server Transact-SQL? Can date and time va...