Start Bulk updating

Bulk updating

Oracle 9i now enables us to bulk fetch from Native Dynamic SQL statements.

DECLARE 2 3 /* 4 * Declare an associative array type of 5 * USER_TABLES structure...

There were workarounds available to overcome this limitation, but they often performed less well.

Oracle 9i Release Two introduces BULK COLLECT support for collections of records.

Bulk binding in PL/SQL was introduced in Oracle 8i as the FORALL statement.