1.

How You Open And Close A Cursor Variable. Why It Is Required?

Answer»

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.

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.


Discussion

No Comment Found

Related InterviewSolutions