首页 » ORACLE 9i-23ai » oracle forall instructs must be followed by DML

oracle forall instructs must be followed by DML

  • 2013/02/26
  • ORACLE 9i-23ai
  • 273 views
  • oracle forall instructs must be followed by DML已关闭评论

Oracle BULK COLLECT and Oracle FORALL are the new features in Oracle 8i, 9i and 10g PL/SQL that can really make a different to you PL/SQL performance.

The keyword FORALL instructs the PL/SQL engine to bulk-bind input collections before sending them to the SQL engine. Although the FORALL statement contains an iteration scheme, it is not a FOR loop. Its syntax follows:

FORALL index IN lower_bound..upper_bound
sql_statement;

The index can be referenced only within the FORALL statement and only as a collection subscript. The SQL statement must be an INSERT, UPDATE, or DELETE statement that references collection elements. And, the bounds must specify a valid range of consecutive index numbers. The SQL engine executes the SQL statement once for each index number in the range.

打赏

对不起，这篇文章暂时关闭评论。

上一篇：

下一篇：