Results for FORALL


21 to 40 of 41 results. Prev  Next
Results per page:   20  | 40


User's Guide and Reference, 9i Release 2 (9.2.0.2)

Tuning PL/SQL Applications

Tuning PL/SQL Performance with Bulk BindsSQL engine just once, with the entire nested table: FORALL i IN depts.FIRST..depts.LAST UPDATE emp … elements, move it into a FORALL statement. If a SELECT INTO, FETCH INTO, or RETURNING INTO clause … on a particular row is not a serious problem, include the keywords SAVE EXCEPTIONS in the FORALL

User's Guide and Reference, 9i Release 2 (9.2.0.2)

PL/SQL Language Elements, 48 of 52

Usage Notes… %BULK_ROWCOUNT is not maintained for bulk inserts because that would be redundant. For example, the FORALL … : FORALL i IN 1..15 INSERT INTO emp (sal) VALUES (sals(i)); You can use the scalar attributes %FOUND

User's Guide and Reference, 9i Release 2 (9.2.0.2)

Native Dynamic SQL

Examples of Dynamic Bulk BindsBULK COLLECT INTO enames; END; To bind the input variables in a SQL statement, you can use the FORALL … NameList; BEGIN empnos:= NumList(1,2,3,4,5); FORALL i IN 1..5 EXECUTE IMMEDIATE 'UPDATE emp SET sal = sal

User's Guide and Reference, 9i Release 2 (9.2.0.2)

PL/SQL Collections and Records

Querying Data into Collections of Records|:host_cursor_variable_name} BULK COLLECT INTO record_variable_name [LIMIT numeric_expression]; FORALL index IN … ]...}] VALUES (record_variable_name(index)) rest_of_insert_stmt FORALL index IN lower_bound..upper_bound … := CharTabTyp('Tim', 'Jon', 'Beth', 'Jenny'); BEGIN FORALL i IN 1..4 INSERT INTO tab1 VALUES(num_tab(i

User's Guide and Reference, 9i Release 2 (9.2.0.2)

PL/SQL Language Elements, 48 of 52

Examples%BULK_ROWCOUNT: DECLARE TYPE NumList IS TABLE OF NUMBER; depts NumList:= NumList(10, 20, 50); BEGIN FORALL j

User's Guide and Reference, 9i Release 2 (9.2.0.2)

PL/SQL Collections and Records

Using Host Arrays with Bulk Bindsin the host environment FORALL i IN:lower..:upper DELETE FROM emp WHERE deptno =:depts(i);... END;

User's Guide and Reference, 9i Release 2 (9.2.0.2)

Native Dynamic SQL

Using Bulk Dynamic SQLstatement FORALL statement COLLECT INTO clause RETURNING INTO clause %BULK_ROWCOUNT cursor attribute The

Error Messages, 9i Release 2 (9.2.0.2)

PL/SQL and FIPS Messages (PLS)

PLS-00436 implementation restriction: cannot reference fields of BULK In-BIND table of recordsplain FORALL DML statement (SELECT/INSERT/DELETE/UPDATE) instead.

User's Guide and Reference, 9i Release 2 (9.2.0.2)

PL/SQL User's Guide and Reference -- Index

Frestriction on, 6-20 when to use, 6-50 FORALL statement, 5-41 syntax, 13-88 using with BULK COLLECT clause

User's Guide and Reference, 9i Release 2 (9.2.0.2)

PL/SQL Language Elements, 48 of 52

Keyword and Parameter Description%BULK_ROWCOUNT This is a composite attribute designed for use with the FORALL statement. This

User's Guide and Reference, 9i Release 2 (9.2.0.2)

Interaction Between PL/SQL and Oracle

Overview of Implicit Cursor Attributes: The SQL cursor has another attribute, %BULK_ROWCOUNT, designed for use with the FORALL statement … . For more information, see \"Counting Rows Affected by FORALL Iterations with the %BULK_ROWCOUNT

User's Guide and Reference, 9i Release 2 (9.2.0.2)

Handling PL/SQL Errors

Continuing after an Exception Is Raisedthe entire operation is complete, as described in \"Handling FORALL Exceptions with the %BULK_EXCEPTIONS Attribute\".

User's Guide and Reference, 9i Release 2 (9.2.0.2)

List of PL/SQL Reserved Words

F List of PL/SQL Reserved WordsEXCEPTION EXCLUSIVE* EXECUTE EXISTS* EXIT EXTENDS EXTRACT FALSE FETCH FLOAT* FOR* FORALL FROM* FUNCTION

User's Guide and Reference, 9i Release 2 (9.2.0.2)

PL/SQL User's Guide and Reference -- Contents

PL/SQL User's Guide and Reference -- Contentsthe FORALL Statement How FORALL Affects Rollbacks Counting Rows Affected by FORALL Iterations with … the %BULK_ROWCOUNT Attribute Handling FORALL Exceptions with the %BULK_EXCEPTIONS Attribute … Collection with the RETURNING INTO Clause Restrictions on BULK COLLECT Using FORALL and BULK COLLECT

User's Guide and Reference, 9i Release 2 (9.2.0.2)

PL/SQL User's Guide and Reference -- Index

Rsavepoints, 6-47 syntax, 13-161 rollbacks rollbacks implicit, 6-47 of FORALL statement, 5-42 statement-level

User's Guide and Reference, 9i Release 2 (9.2.0.2)

PL/SQL User's Guide and Reference -- Index

S, 6-23, 13-83 FORALL, 5-41 GOTO, 13-99 IF, 13-101 INSERT, 13-104 LOCK TABLE, 13-110 LOOP, 13-112

Application Developer's Guide - Fundamentals, 9i Release 2 (9.2.0.2)

Using Procedures and Packages

Stored Program Units (Procedures, Functions, and Packages)bulk binds to improve performance. DML Statements that Reference Collections The FORALL keyword can … FORALL i IN Id.FIRST..Id.LAST -- bulk-bind the VARRAY UPDATE Emp_tab SET Sal = 1.1 * Sal WHERE Mgr = Id … -insert or bulk-update the data using a loop like: FORALL i in Emp_Data.FIRST..Emp_Data.LAST INSERT … Loops that Reference

User's Guide and Reference, 9i Release 2 (9.2.0.2)

PL/SQL Language Elements, 20 of 52

Keyword and Parameter Description… %BULK_ROWCOUNT Designed for use with the FORALL statement, this is a composite attribute of the

Generic Documentation Master Index, 9i Release 2 (9.2.0.2)

Oracle9i Database Master Index: F (Release 2 (9.2))

Oracle9 i Database Master Index: F (Release 2 (9.2))Programmer's Guide) FORALL statement       [entry #2] (PL/SQL User's Guide and Reference) syntax

Generic Documentation Master Index, 9i Release 2 (9.2.0.2)

Oracle9i Database Master Index: R (Release 2 (9.2))

Oracle9 i Database Master Index: R (Release 2 (9.2))Reference) of FORALL statement (PL/SQL User's Guide and Reference) ORA-02067 error (Administrator's Guide


Was this page helpful?