DEVFYI - Developer Resource - FYI

What is difference between a Cursor declared in a procedure and Cursor declared in a package specification ?

ORACLE Interview Questions and Answers (Part 3)


(Continued from previous question...)

500. What is difference between a Cursor declared in a procedure and Cursor declared in a package specification ?

A cursor declared in a package specification is global and can be accessed by other procedures or procedures in a package.
A cursor declared in a procedure is local to the procedure that can not be accessed by other procedures.

(Continued on next question...)

Other Interview Questions