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.