Process non-consecutive array items in FORALL

Friday Nov 3rd 2006 by DatabaseJournal.com Staff
Share:

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...

[From Builder.com]

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 http://builder.com.com/5100-6388_14-6130359.html?tag=sc

Share:
Home
Mobile Site | Full Site
Copyright 2017 © QuinStreet Inc. All Rights Reserved