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 BULK


1 to 20 of 178 results. Previous page Prev  Next next page
Results per page:   20  | 40 | 60


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

3 Loading Spatial Data

3.1 Bulk LoadingBulk loading can import large amounts of ASCII data into an Oracle database. Bulk loading is

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

FETCH Statement

Restrictions on BULK COLLECTfollowing 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

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

7 Performing SQL Operations with Native Dynamic SQL

Using Bulk Dynamic SQLBulk 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

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

7 Performing SQL Operations with Native Dynamic SQL

Examples of Dynamic Bulk BindsExample 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;

Advanced Replication, 10g Release 1 (10.1)

A Troubleshooting Replication Problems

Bulk Updates and Constraint Violationsperforms constraint checking at the end of each statement. While a bulk update may not violate a

Oracle® Advanced Security Administrator's Guide, 10g Release 1 (10.1)

G Using the User Migration Utility

Bulk User Migration Process OverviewBulk user migration is a two-phase process. In phase one, you start the migration process by

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

3 Loading Spatial Data

3.1.1 Bulk Loading SDO_GEOMETRY Objectsin 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

Application Developer's Guide - Workspace Manager, 10g Release 1 (10.1)

1 Introduction to Workspace Manager

1.15.8 Bulk Load Support SubprogramsBulk 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

Application Developer's Guide - Expression Filter, 10g Release 1 (10.1)

5 Using Expression Filter with Utilities

5.1 Bulk Loading of Expression DataBulk 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');

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

7 Performing SQL Operations with Native Dynamic SQL

Using Dynamic SQL with Bulk SQLBulk 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

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

6 Performing SQL Operations from PL/SQL

Selecting Multiple Rows: BULK COLLECT Clausethrough 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

Pro*COBOL® Programmer's Guide, 10g Release 1 (10.1)

10 ANSI Dynamic SQL

10.4.2 Using Tables for Bulk OperationsOracle 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

Pro*C/C++ Programmer's Guide, 10g Release 1 (10.1)

14 ANSI Dynamic SQL

14.3.2 Using Arrays for Bulk OperationsOracle 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

Application Developer's Guide - Workspace Manager, 10g Release 1 (10.1)

1 Introduction to Workspace Manager

1.7 Bulk Loading into Version-Enabled TablesYou 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

Application Developer's Guide - Workspace Manager, 10g Release 1 (10.1)

New and Changed Features

Bulk Loading into Version-Enabled TablesYou can use SQL*Loader to perform bulk loading into version-enabled tables, but you must also use

Heterogeneous Connectivity Administrator's Guide, 10g Release 1 (10.1)

4 Using Heterogeneous Services Agents

Optimizing Data Transfers Using Bulk Fetchinitialization parameters specific to a gateway Optimizing Data Transfers Using Bulk Fetch When an

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

3 Loading Spatial Data

3.1.2 Bulk Loading Point-Only Data in SDO_GEOMETRY Objectsa Bulk Load of Point-Only Data LOAD DATA INFILE * TRUNCATE CONTINUEIF NEXT(1:1) = '#' INTO TABLE

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 ClauseUsing 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

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 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

Error Messages, 10g Release 1 (10.1)

36 PLS-00049 to PLS-01913

PLS-00431: bulk SQL attributes must use a single indexa part of an expression. Action: Use FORALL variable only as a collection subscript. PLS-00431: bulk SQL attributes must use a single index