Describe ref cursor in Oracle.

Describe ref cursor in Oracle.

Answer
Cursor is a reference type in oracle. We can allocate different storage locations to the cursor when the program runs.
Syntax
Type is REF CURSOR
RETURN
Return_type – Name of new reference type.
Return Type – This represents select list type that will be returned by the query.

Similar Threads:

• Explain the attributes of implicit cursor.
• Oracle Forms 4.5 FAQ
• Oracle FAQ
• What Is Parallel Cursor Concept
• A Sample Hide & Get Cursor in Interactive Programming