Basic Oracle Concepts and Programming Question:

Download Job Interview Questions and Answers PDF

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.

Download Oracle Database Interview Questions And Answers PDF

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