DEVFYI - Developer Resource - FYI

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

ORACLE Interview Questions and Answers (Part 3)


(Continued from previous question...)

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

The return type for a cursor must be a record type.It can be declared explicitly as a user-defined or %ROWTYPE can be used. eg TYPE t_studentsref IS REF CURSOR RETURN students%ROWTYPE

(Continued on next question...)

Other Interview Questions