OPEN-FOR associates cursor variable with multi-row query - SQL Operations

Q.  Which statement associates a cursor variable with a multi-row query, executes the query, and identifies the result set?
- Published on 09 Jul 15

a. OPEN-FOR
b. FETCH
c. CLOSE
d. All mentioned above

ANSWER: OPEN-FOR
 
The query associated with a cursor variable executes using the OPEN-FOR statement. It helps in identifying the result set.

Post your comment / Share knowledge


Enter the code shown above:
 
(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)