How do you declare a ref cursor?
How do you declare a ref cursor? With a cursor variable, you simply pass the reference to that cursor. To declare a cursor variable, you use the REF CURSOR is the data type. PL/SQL has two forms of REF CURSOR typeS: strong typed and weak typed REF CURSOR . The following shows an example of a strong REF CURSOR . What is reference cursor in PL SQL? A REF CURSOR is a PL/SQL data type whose value is the memory address of a query work area on the database. In essence, a REF CURSOR is a pointer or a handle...