DEVFYI - Developer Resource - FYI

How you open and close a cursor variable.Why it is required?

ORACLE Interview Questions and Answers (Part 3)


(Continued from previous question...)

533. How you open and close a cursor variable.Why it is required?

OPEN cursor variable FOR SELECT...Statement
CLOSE cursor variable In order to associate a cursor variable with a particular SELECT statement OPEN syntax is used. In order to free the resources used for the query CLOSE statement is used.

(Continued on next question...)

Other Interview Questions