In a previous TechRepublic column about SQL Server 2005, I showed how you can convert some of your iterative queries (cursors) to set-based operations in order to enhance performance. You should ...

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.