Statements used to control cursor variable - SQL Operations

Q.  Which statements are used to control a cursor variable?
- Published on 19 Oct 15

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

ANSWER: All mentioned above
 
There are three statements used to control a cursor variable:
1. OPEN-FOR - open a cursor variable for multi-row query
2. FETCH - it fetches the rows for the result set
3. CLOSE - when all the rows are processed the cursor variable is closed.

Related Content

➨ 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.)
▲