DBA > Job Interview Questions > Oracle DBA Interview questions and Answers

What is use of a cursor variable? How it is defi

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

What is use of a cursor variable? How it is defined?

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 ;

(Continued on next question...)

Other Job Interview Questions