Which of the following is/ are true about Explicit Cursors?

Options
- Cursor stores multiple records, but only one record can be processed at a time
- When you fetch a row the current row position automatically moves to next row
- Only a
- Both a and b

CORRECT ANSWER : Both a and b

Discussion Board
Explicit cursors

Explicit cursors must be created when you are executing a SELECT statement that returns more than one row. Even though the cursor stores multiple records, only one record can be processed at a time, which is called as current row. When you fetch a row the current row position moves to next row. Both implicit and explicit cursors have the same functionality, but they differ in the way they are accessed.

Prajakta Pandit 02-22-2017 01:54 AM

Write your comments


Enter the code shown above:

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


Related Content

Advertisement
 
▲