Collections:
Loop through the Implicit Cursor in Oracle
How To Loop through Data Rows in the Implicit Curosr in Oracle?
✍: FYIcenter.com
You use the FOR ... IN ... LOOP statement to loop through data rows in the implicit cursor as the following syntax:
FOR row IN dml_statement LOOP (statement block with row.field) END LOOP;
Here "row" is a local RECORD type variable with fields automatically defined to match the fields in the data rows resulted from the DML statement. Here is a good tutorial exercise on loop through data rows with the implicit cursor:
BEGIN FOR row IN (SELECT * FROM employees WHERE manager_id = 101) LOOP DBMS_OUTPUT.PUT_LINE('Name = ' || row.last_name); END LOOP; END; / Name = Greenberg Name = Whalen Name = Mavris Name = Baer Name = Higgins
⇒ Define an Explicit Cursor in Oracle
⇐ Attributes of the Implicit Cursor in Oracle
2018-07-22, 1886🔥, 0💬
Popular Posts:
How to download and install Microsoft .NET Framework Version 2.0 in SQL Server? .NET Framework Versi...
How To Use "IF ... ELSE IF ..." Statement Structures in SQL Server Transact-SQL? "IF ... ELSE IF ......
Where to find answers to frequently asked questions on PHP Connections and Query Execution for MySQL...
How To Use SQL*Plus Built-in Timers in Oracle? If you don't have a stopwatch/timer and want to measu...
How To Assign Debug Privileges to a User in Oracle? In order to run SQL Developer in debug mode, the...