|
Re: SQL and PL/SQL [message #8561 is a reply to message #8490] |
Sat, 30 August 2003 01:49 |
mahesh.p@b2bsoftech.com
Messages: 1 Registered: August 2003
|
Junior Member |
|
|
Bulk binding improves performance by minimizing the number of context switches between the PL/SQL and SQL engines. With bulk binding, entire collections, not just individual elements, are passed back and forth.
Using the following commands, clauses, and cursor attribute, your applications can construct bulk SQL statements, then execute them dynamically at run time:
BULK FETCH statement
BULK EXECUTE IMMEDIATE statement
FORALL statement
COLLECT INTO clause
RETURNING INTO clause
%BULK_ROWCOUNT cursor attribute
|
|
|