Opening a cursor executes query & identifies result set - SQL Operations

Q.  Which of the following executes the query and identifies the result set, consisting of all rows that meet the query search criteria.
- Published on 09 Jul 15

a. Fetching with a Cursor
b. Opening a cursor
c. Fetching bulk data with a cursor
d. None of the above

ANSWER: Opening a cursor
 
Once we have declared the cursor the next thing would be to open the cursor. The cursor is opened with the OPEN statement. Syntax: OPEN cursor_name;

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