Scribd
Upload
114 views1 page

Oracle PL/SQL Cursor Guide

This document discusses Oracle PL/SQL cursors, which are used to retrieve multiple rows from a database query. It lists 16 interview questions about cursors, covering topics such as explicit cursors, which are declared and opened by the developer; implicit cursors, which are automatically created; cursor attributes; using cursors in for loops; passing parameters to cursors; and the FOR UPDATE clause and CURRENT OF operator for updating rows retrieved by a cursor.

Uploaded by

SusantoPaul
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
114 views1 page

Oracle PL/SQL Cursor Guide

This document discusses Oracle PL/SQL cursors, which are used to retrieve multiple rows from a database query. It lists 16 interview questions about cursors, covering topics such as explicit cursors, which are declared and opened by the developer; implicit cursors, which are automatically created; cursor attributes; using cursors in for loops; passing parameters to cursors; and the FOR UPDATE clause and CURRENT OF operator for updating rows retrieved by a cursor.

Uploaded by

SusantoPaul
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 1

Oracle PL/SQL Interview Questions

CURSORS
1. What is a Cursor?
2. What are the different types of Cursors?
3. What is an Explicit Cursor?
4. What is an Active Set in cursor?
5. What are the general steps to use Explicit Cursors?
6. What happens when we Declare the Cursor?
7. What happens when we Open the Cursor?
8. What happens when we Fetch from the Cursor?
9. What happens when we Close the Cursor?
10. Explain Cursor For Loop.
11. What is an Implicit Cursor?
12. What are the various Cursor attributes?
13. Demonstrate Cursor For Loop using Sub queries.
14. Demonstrate Cursors with parameters.
15. For Update Clause in Cursor.
16. where CURRENT OF clause in Cursor.

You might also like