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
3.1 Bulk Loading → Bulk loading can import large amounts of ASCII data into an Oracle database. Bulk loading is
Restrictions on BULK COLLECT → following restrictions apply to the BULK COLLECT clause: You cannot bulk collect into an associative array … that has a string type for the key. You can use the BULK COLLECT clause only in server-side … client-side programs. All target variables listed in a BULK COLLECT INTO clause must be collections … , multiple
Using Bulk Dynamic SQL → Bulk SQL passes entire collections back and forth, not just individual elements. This technique … . Using the following commands, clauses, and cursor attribute, your applications can construct bulk SQL … statements, then execute them dynamically at run time: BULK FETCH statement BULK EXECUTE IMMEDIATE … Overhead
Examples of Dynamic Bulk Binds → Example 7-5 Dynamic SQL with BULK COLLECT INTO Clause You can bind define variables in a dynamic … query using the BULK COLLECT INTO clause. As the following example shows, you can use that clause in a … bulk FETCH or bulk EXECUTE IMMEDIATE statement: DECLARE TYPE EmpCurTyp IS REF CURSOR; TYPE NumList … NameList;
Bulk Updates and Constraint Violations → performs constraint checking at the end of each statement. While a bulk update may not violate a
Bulk User Migration Process Overview → Bulk user migration is a two-phase process. In phase one, you start the migration process by
3.1.1 Bulk Loading SDO_GEOMETRY Objects → in Example 2-1 in Section 2.1. Example 3-1 Control File for a Bulk Load of Cola Market Geometries … shows the control file for loading the data. Example 3-2 Control File for a Bulk Load of Polygons
1.15.8 Bulk Load Support Subprograms → Bulk load support subprograms enable SQL*Loader to be used for bulk loading data into version … -enabled tables, as explained in Section 1.7. Table 1-12 shows the subprograms available for bulk loading … support. Table 1-12 Bulk Loading Support Subprograms Procedure Description GetBulkLoadVersion … Starts the
5.1 Bulk Loading of Expression Data → Bulk loading can import large amounts of ASCII data into an Oracle database. You use the SQL*Loader … utility to bulk load data. For SQL*Loader operations, the expression data is treated as strings … achieve faster bulk loads, the expression validation can be bypassed by following these steps: Drop … ', expr_col => 'Interest');
Using Dynamic SQL with Bulk SQL → Bulk binding lets Oracle bind a variable in a SQL statement to a collection of values. The … bulk binds: EXECUTE IMMEDIATE, FETCH, and FORALL. EXECUTE IMMEDIATE You can use the BULK COLLECT INTO … in a separate collection. You can use the RETURNING BULK COLLECT INTO clause with the EXECUTE … collections. FETCH
Selecting Multiple Rows: BULK COLLECT Clause → through a result set one row at a time, you can use the BULK COLLECT clause. When you query only certain … employee_id, last_name, salary FROM employees BULK COLLECT INTO all_employee_ids, all_last_names … columns: SELECT * FROM employees BULK COLLECT INTO all_employees; FOR i IN all_employees.FIRST
10.4.2 Using Tables for Bulk Operations → Oracle extends the SQL92 ANSI dynamic standard by providing bulk operations. To use bulk operations … PREPARE statements. The following code sample illustrates a bulk operation with no output
14.3.2 Using Arrays for Bulk Operations → Oracle extends the SQL92 ANSI dynamic standard by providing bulk operations. To use bulk operations … PREPARE statements. The following code example illustrates a bulk operation with no output
1.7 Bulk Loading into Version-Enabled Tables → You can use SQL*Loader to perform bulk loading into version-enabled tables, but you must also call … -path and conventional-path bulk loading of data into either the latest version of any workspace or … (unless non- LIVE workspaces have updated the data). Follow these general steps for bulk loading into a … which the bulk
Bulk Loading into Version-Enabled Tables → You can use SQL*Loader to perform bulk loading into version-enabled tables, but you must also use
Optimizing Data Transfers Using Bulk Fetch → initialization parameters specific to a gateway Optimizing Data Transfers Using Bulk Fetch When an
3.1.2 Bulk Loading Point-Only Data in SDO_GEOMETRY Objects → a Bulk Load of Point-Only Data LOAD DATA INFILE * TRUNCATE CONTINUEIF NEXT(1:1) = '#' INTO TABLE
Retrieving Query Results into Collections with the BULK COLLECT Clause → Using the keywords BULK COLLECT with a query is a very efficient way to retrieve the result set … INTO clause. With the BULK COLLECT clause, all the variables in the INTO list must be collections … , last_name -- Retrieve data for 10 arbitrary employees. BULK COLLECT INTO enums, names FROM employees … elements. Since the processing
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 … statement sends INSERT, UPDATE, or DELETE statements in batches, rather than one at a time. The BULK … database rows, the use of bulk SQL can improve performance considerably. The assigning of values to PL … assigned to a PL/SQL variable
PLS-00431: bulk SQL attributes must use a single index → a part of an expression. Action: Use FORALL variable only as a collection subscript. PLS-00431: bulk SQL attributes must use a single index