The cursor example above produces 11114 logical reads from the database. The following snippet performs the same operation as the cursor above but through the use of a WHILE loop.

It would be ideal if PL/SQL would allow us to create the cursor during OPEN, and then have some new command that allowed us to EXECUTE <cursor> USING …. Even in Oracle 10g, there is no such command.