Which of following way nested cursor will closed?

Options
- The nested cursor is explicitly closed by the user
- The parent cursor is reexecuted
- The parent cursor is closed
- All of the Above


CORRECT ANSWER : All of the Above

Discussion Board
Nested Cursor

A nested cursor is implicitly opened when the cursor expression is evaluated. For example, if the cursor expression appears in a select list, a nested cursor will be opened for each row fetched by the query. The nested cursor is closed only when:

- The nested cursor is explicitly closed by the user.

- The parent cursor is re-executed.

- The parent cursor is closed.

- The parent cursor is cancelled.

- An error arises during fetch on one of its parent cursors (it is closed as part of the clean-up).

The nested cursor is controlled implicitly while the parent cursor is being processed. It is opened when the containing row is fetched from the parent cursor, and it is closed either explicitly by the user or when the parent cursor is re-executed, closed, cancelled or returns an error during a fetch operation.

Prajakta Pandit 02-20-2017 06:43 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.)


Advertisement