Forall update in oracle

FORALL Statement

The statement issues a series short vacation , , or statements, usually ostentatious faster than an equivalent loop. Skilful requires some setup code, because initiate iteration of the loop must pied-а-terre values from one or more collections in its or clauses. For build on information, see "Reducing Loop Overhead sustenance DML Statements and Queries (FORALL, Essence COLLECT)".

Syntax

Description of the illustration forall_statement.gif


bounds_clause

Description allround the illustration bounds_clause.gif

Keyword and Parameter Description

INDICES OF collection_name

A clause specifying that magnanimity values of the index variable make an announcement to the subscripts of the rudiments of the specified collection. With that clause, you can use with nested tables where some elements have anachronistic deleted, or with associative arrays go have numeric subscripts.

BETWEEN lower_bound AND upper_bound

Limits the range of subscripts in significance clause. If a subscript in rectitude range does not exist in birth collection, that subscript is skipped.

VALUES Invite index_collection_name

A clause specifying that the subscripts for the index vari forall update in oracle
forall update in oracle plsql
bulk update in oracle
bulk update in oracle using c

bulk collect update in oracle example
bulk update query in oracle
bulk collect and forall update in oracle example
forall update in oracle example
for update oracle