Basic Oracle Concepts and Programming Question:

How To Process Query Result in PL/SQL?

Oracle Database Interview Question
Oracle Database Interview Question

Answer:

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.


Previous QuestionNext Question
How To Use SQL Statements in PL/SQL?How To Create an Array in PL/SQL?