Thursday, 24 May 2012

How can explicit cursors be used to fetch multiple rows? | PL SQL

A loop must be defined to fetch multiple rows from an explicit cursor. It will fetch one row from the active cursor set on each iteration of the loop, as shown in the following code: