1.

What Is Use Of A Cursor Variable? How It Is Defined?

Answer»

Cursor variable is USED to MARK a work area where Oracle stores a multi-row QUERY output for processing. It is LIKE a pointer in C or PASCAL. Because it is a TYPE, it is defined as TYPE REF CURSOR RETURN ;.

Cursor variable is used to mark a work area where Oracle stores a multi-row query output for processing. It is like a pointer in C or Pascal. Because it is a TYPE, it is defined as TYPE REF CURSOR RETURN ;.



Discussion

No Comment Found