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