Home >> FAQs/Tutorials >> Oracle Tutorials
Oracle Tutorials - Process Query Result in PL/SQL
(Continued from previous topic...)
How To Process Query Result in PL/SQL?
You can run queries (SELECT statements) in a PL/SQL code blocks,
and process the results a loop as shown in the following
SQL> set serveroutput on;
2 FOR row IN
3 (SELECT * FROM employees WHERE manager_id = 101)
5 DBMS_OUTPUT.PUT_LINE('Name = ' || row.last_name);
6 END LOOP;
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.
(Continued on next topic...)
- What Is PL/SQL?
- What Are the Types PL/SQL Code Blocks?
- How To Define an Anonymous Block?
- How Many Anonymous Blocks Can Be Defined?
- How To Run the Anonymous Block Again?
- What Is a Stored Program Unit?
- How To Create a Stored Program Unit?
- How To Execute a Stored Program Unit?
- How Many Data Types Are Supported?
- What Are the Execution Flow Control Statements?
- How To Use SQL Statements in PL/SQL?
- How To Process Query Result in PL/SQL?
- How To Create an Array in PL/SQL?
- How To Manage Transaction Isolation Level?
- How To Pass Parameters to Procedures?
- How To Define a Procedure inside Another Procedure?
- What Do You Think about PL/SQL?