Program to select multiple rows of data from database & then process each row individually - PL/SQL
Q. Which of the following provides a way for your program to select multiple rows of data from the database and then process each row individually.- Published on 01 Jul 15
a. PL/SQL Cursors
b. PL/SQL Trigger
c. PL/SQL Select
d. PL/SQL Process
ANSWER: PL/SQL Cursors
Oracle creates a memory area which is known as the context area where the SQL statement is processed and which contains all the information which is needed for the processing. The cursor is the pointer to this context area.