Table of Contents
Any code that switches between pl/sql and oracle will be expensive in performing the right database operation. As long as possible code most of your work in sql. In my experience its almost always better to use SQL instead of PL/SQL ( when using PL/SQL you have to pay "penalty" of context switches from SQL to PL/SQL and back ).