You are using an outdated browser. Please upgrade to the latest version for the best experience.
How do I narrow my search results?

After you submit your search query:

  1. On the Refine Search results page, select one or more categories of products or services from the left sidebar.
  2. Then for a category with search results, click Select to choose your product and release filters, and then click OK.

For search queries that contain multiple words, surround the query with quotes, and then resubmit your query. Example: "database cloud service"

How do I find the documentation for my product or service?

From the home page, click the technology categories for your products or services. If you do not know which category to pick, try the following features:

  • Click the Find a product tab and search for your product or service.
  • Click Browse All Products & Services at the bottom of the home page to view an alphabetical listing of products and services.
  • Apple Safari: Version 6
  • Google Chrome: Version 29 and later
  • Mozilla Firefox: Version 24 and later
  • Microsoft Internet Explorer: Version 9 and later
Results for FORALL


1 to 20 of 36 results. Previous page Prev  Next next page


User's Guide and Reference, 10g Release 1 (10.1)

FORALL Statement

FORALL StatementThe FORALL statement issues a series of INSERT, UPDATE, or DELETE statements, usually much faster … "Reducing Loop Overhead for DML Statements and Queries (FORALL, BULK COLLECT)". Syntax Description of the … this clause, you can use FORALL with nested tables where some elements have been deleted, or with … for the FORALL

User's Guide and Reference, 10g Release 1 (10.1)

11 Tuning PL/SQL Applications for Performance

Using the FORALL StatementThe keyword FORALL lets you run multiple DML statements very efficiently. It can only repeat a … single DML statement, unlike a general-purpose FOR loop. For full syntax and restrictions, see "FORALL … Statement". The SQL statement can reference more than one collection, but FORALL only improves … PLS_INTEGER. The FORALL

User's Guide and Reference, 10g Release 1 (10.1)

11 Tuning PL/SQL Applications for Performance

Reducing Loop Overhead for DML Statements and Queries (FORALL, BULK COLLECT)PL/SQL and SQL by using the PL/SQL language features known collectively as bulk SQL. The FORALLFORALL statement instead of a loop construct. To speed up SELECT statements, include the BULK COLLECT … restrictions for these statements, see "FORALL Statement" and "SELECT INTO Statement".

Error Messages, 10g Release 1 (10.1)

36 PLS-00049 to PLS-01913

PLS-00435: DML statement without BULK In-BIND cannot be used inside FORALLsupported types for record fields. PLS-00435: DML statement without BULK In-BIND cannot be used inside FORALL

Error Messages, 10g Release 1 (10.1)

36 PLS-00049 to PLS-01913

PLS-00432: implementation restriction: cannot use FORALL and BULK COLLECT INTO together in SELECT statementsinteger datatype. PLS-00432: implementation restriction: cannot use FORALL and BULK COLLECT INTO together in SELECT statements

Error Messages, 10g Release 1 (10.1)

36 PLS-00049 to PLS-01913

PLS-00437: FORALL bulk index cannot be used in string clauseFORALL DML statement (SELECT/INSERT/DELETE/UPDATE) instead PLS-00437: FORALL bulk index cannot be used in string clause

Error Messages, 10g Release 1 (10.1)

36 PLS-00049 to PLS-01913

PLS-00430: FORALL iteration variable string is not allowed in this contextvalues. PLS-00430: FORALL iteration variable string is not allowed in this context

User's Guide and Reference, 10g Release 1 (10.1)

7 Performing SQL Operations with Native Dynamic SQL

Using Dynamic SQL with Bulk SQLbulk binds: EXECUTE IMMEDIATE, FETCH, and FORALL. EXECUTE IMMEDIATE You can use the BULK COLLECT INTO … column of a cursor in a separate collection. FORALL You can put an EXECUTE IMMEDIATE statement with … the RETURNING BULK COLLECT INTO inside a FORALL statement. You can store the results of all the … collection of table names

User's Guide and Reference, 10g Release 1 (10.1)

7 Performing SQL Operations with Native Dynamic SQL

Using Bulk Dynamic SQLstatement FORALL statement COLLECT INTO clause RETURNING INTO clause %BULK_ROWCOUNT cursor attribute … Overhead for DML Statements and Queries (FORALL, BULK COLLECT)". Refer to that section for background information.

User's Guide and Reference, 10g Release 1 (10.1)

SQL Cursor

SQL Cursor%BULK_EXCEPTIONS, designed for use with the FORALL statement. For more information, see "Querying Data … Description %BULK_ROWCOUNT A composite attribute designed for use with the FORALL statement. This attribute … encountered by a FORALL statement that uses the SAVE EXCEPTIONS clause. You must loop through its elements to … %BULK_EXCEPTIONS.COUNT,

User's Guide and Reference, 10g Release 1 (10.1)

7 Performing SQL Operations with Native Dynamic SQL

Examples of Dynamic Bulk Binds; END; / Example 7-7 Dynamic SQL Inside FORALL Statement To bind the input variables in a SQL statement … , you can use the FORALL statement and USING clause, as shown below. The SQL statement cannot be a … NumList; enames NameList; BEGIN empnos:= NumList(1,2,3,4,5); FORALL i IN 1..5 EXECUTE IMMEDIATE 'UPDATE

User's Guide and Reference, 10g Release 1 (10.1)

11 Tuning PL/SQL Applications for Performance

11 Tuning PL/SQL Applications for PerformanceTracing PL/SQL Programs Reducing Loop Overhead for DML Statements and Queries (FORALL, BULK COLLECT

User's Guide and Reference, 10g Release 1 (10.1)

11 Tuning PL/SQL Applications for Performance

Retrieving Query Results into Collections with the BULK COLLECT Clause) || ': ' || names(i)); END LOOP; END; / DROP TABLE emp2; Using FORALL and BULK COLLECT Together You can combine … the BULK COLLECT clause with a FORALL statement. The output collections are built up as the FORALL … collection ENUMS. The collection DEPTS has 3 elements, so the FORALL statement iterates 3 times. If

User's Guide and Reference, 10g Release 1 (10.1)

13 PL/SQL Language Elements

13 PL/SQL Language ElementsIMMEDIATE Statement EXIT Statement Expressions FETCH Statement FORALL Statement Functions GOTO Statement

Error Messages, 10g Release 1 (10.1)

36 PLS-00049 to PLS-01913

PLS-00433: inconsistent package STANDARDCause: SELECT statement contains both the FORALL and BULK COLLECT INTO phrases. Action: Dn not use … FORALL and BULK COLLECT INTO together in SELECT statements. PLS-00433: inconsistent package STANDARD

User's Guide and Reference, 10g Release 1 (10.1)

DELETE Statement

DELETE StatementLoop Overhead for DML Statements and Queries (FORALL, BULK COLLECT)". returning_clause Returns values … INTO my_ename, my_job; END; You can combine the BULK COLLECT clause with a FORALL statement, in which … elements when the statement completes: FORALL j IN depts.FIRST..depts.LAST DELETE FROM emp WHERE deptno

User's Guide and Reference, 10g Release 1 (10.1)

List of Examples

List of ExamplesBULK COLLECT INTO Clause 7-7 Dynamic SQL Inside FORALL Statement 8-1 Simple PL/SQL Procedure 8-2 Simple … Issuing DELETE Statements in a Loop 11-2 Issuing INSERT Statements in a Loop 11-3 Using FORALL with Part … of a Collection 11-4 Using FORALL with Non-Consecutive Index Values 11-5 Bulk Operation That

User's Guide and Reference, 10g Release 1 (10.1)

5 Using PL/SQL Collections and Records

Updating the Database with PL/SQL Record Valuesyou issue the UPDATE through the FORALL statement, you can update a set of rows using values from an … RETURNING clause to retrieve new values into a record. If you issue the UPDATE through the FORALL statement

User's Guide and Reference, 10g Release 1 (10.1)

F List of PL/SQL Reserved Words

F List of PL/SQL Reserved WordsFLOAT* FOR* FORALL FROM* FUNCTION GOTO GROUP* HAVING* HEAP HOUR IF IMMEDIATE* IN* INDEX* INDICATOR

User's Guide and Reference, 10g Release 1 (10.1)

5 Using PL/SQL Collections and Records

Inserting PL/SQL Records into the Databasemakes your code more readable and maintainable. If you issue the INSERT through the FORALL statement