Discussion Board

Explicit Cursor Explicit cursors can be declared by us for the queries that return more than one row. In explicit cursor, 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. Oracle provides some attributes known as Explicit Cursor Attributes to control the data processing while using cursors. We use these attributes to avoid errors while accessing cursors through OPEN, FETCH and CLOSE Statements. An explicit cursor is defined in the declaration section of the PL/SQL Block. It is created on a SELECT Statement which returns more than one row. Prajakta Pandit 02-10-2017 01:55 AM

Write your comments

*

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

*

*