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
💬 Discuss
✅ Correct Answer: (A) PL/SQL Cursors
Explanation: 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.

Published by Akshay Kulkarni ⭐ 3.46K Points at 22-Oct-2022 04:32 pm in MySQL

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.

💬 Discussion

📊 Question Analytics

👁️
260
Total Visits
📽️
4 y ago
Published
🎖️
Akshay Kulkarni
Publisher
📈
93%
Success Rate