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

*

* Email must be in the form someone@domain.com

*

*