Home / Programming MCQs / MySQL MCQs / Question

A

Akshay Kulkarni • 3.46K Points
Extraordinary

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.

(A) PL/SQL Cursors
(B) PL/SQL Trigger
(C) PL/SQL Select
(D) PL/SQL Process
Explanation by: Akshay Kulkarni
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.

You must be Logged in to update hint/solution

Discusssion

Login to discuss.