Process non-consecutive array items in FORALL

November 3, 2006


Executing Data Manipulation Language (DML) statements within a PL/SQL loop is time consuming because each time through the loop a switch is made from the PL/SQL engine to the SQL engine. A better approach is to use the FORALL statement, which passes the SQL statement only once along with a collection of fill-in values.

The article continues at

The Network for Technology Professionals



Legal Notices, Licensing, Permissions, Privacy Policy.
Advertise | Newsletters | E-mail Offers