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, 1637🔥, 0💬
Popular Posts:
What Is Program Global Area (PGA) in Oracle? A Program Global Area (PGA) is a memory buffer that is ...
How To Calculate Age in Days, Hours and Minutes in SQL Server Transact-SQL? On many Web sites, news ...
Is SQL Server Transact-SQL case sensitive? No. Transact-SQL is not case sensitive. Like the standard...
How To Verify a User name with SQLCMD Tool in SQL Server? The quickest way to verify a user name in ...
What is sqlservr.exe - Process - SQL Server (SQLEX?PRESS) in SQL Server? Process sqlservr.exe is the...