Question

Explain what Is The Function Of Open Cursor Command?

Answer 1

The following operations occur when the OPEN cursor command is executed for a cursor:

•  Memory area for processing is allocated
•  The SELECT statement is parsed
•  The input variables are assigned the values by obtaining the memory addresses
•  The active set of rows that fulfill the select criteria are identified
•  The pointer is set just before the first row of the active set