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.

Post your comment / Share knowledge


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)