Reference Datatypes
The datatypes in this category contain references to other data sets:
- REF CURSOR
A PL/SQL pointer to a SQL cursor that can return a row from the database. After an instance of this datatype is OPENed, you can FETCH rows with it. You should CLOSE the REF CURSOR when finished with it.
- REF object
Points to an instance of object. Used to share access to the object between subprograms in PL/SQL or between reference objects in SQL.
Get Oracle in a Nutshell now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.