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

What should be the return type for a cursor vari

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

(Continued from previous question...)

What should be the return type for a cursor variable. Can we use a scalar data type as return type?

The return type of a cursor variable can be %ROWTYPE or record_name%TYPE or a record type or a ref cursor type. A scalar data type like number or varchar can’t be used but a record type may evaluate to a scalar value.

(Continued on next question...)

Other Job Interview Questions