How do I narrow my search results?
After you submit your search query:
- On the Refine Search results page, select one or more categories of products or services from the left sidebar.
- 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
FORALL Statement → The 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
Using the FORALL Statement → The 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
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 FORALL … FORALL 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".
PLS-00435: DML statement without BULK In-BIND cannot be used inside FORALL → supported types for record fields. PLS-00435: DML statement without BULK In-BIND cannot be used inside FORALL
PLS-00432: implementation restriction: cannot use FORALL and BULK COLLECT INTO together in SELECT statements → integer datatype. PLS-00432: implementation restriction: cannot use FORALL and BULK COLLECT INTO together in SELECT statements
PLS-00437: FORALL bulk index cannot be used in string clause → FORALL DML statement (SELECT/INSERT/DELETE/UPDATE) instead PLS-00437: FORALL bulk index cannot be used in string clause
PLS-00430: FORALL iteration variable string is not allowed in this context → values. PLS-00430: FORALL iteration variable string is not allowed in this context
Using Dynamic SQL with Bulk SQL → bulk 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
Using Bulk Dynamic SQL → statement 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.
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,
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
11 Tuning PL/SQL Applications for Performance → Tracing PL/SQL Programs Reducing Loop Overhead for DML Statements and Queries (FORALL, BULK COLLECT
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
13 PL/SQL Language Elements → IMMEDIATE Statement EXIT Statement Expressions FETCH Statement FORALL Statement Functions GOTO Statement
PLS-00433: inconsistent package STANDARD → Cause: 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
DELETE Statement → Loop 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
List of Examples → BULK 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
Updating the Database with PL/SQL Record Values → you 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
F List of PL/SQL Reserved Words → FLOAT* FOR* FORALL FROM* FUNCTION GOTO GROUP* HAVING* HEAP HOUR IF IMMEDIATE* IN* INDEX* INDICATOR