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 204 results. Previous page Prev  Next next page
Results per page:   20  | 40 | 60


Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

DBMS_SQL, 2 of 2

Bulk Array BindsBulk selects, inserts, updates, and deletes can enhance the performance of applications by bundling

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

Native Dynamic SQL

Using Bulk Dynamic SQLIn this section, you learn how to add the power of bulk binding to dynamic SQL. Bulk binding … bulk binding, entire collections, not just individual elements, are passed back and forth. Using … the following commands, clauses, and cursor attribute, your applications can construct bulk SQL … statements, then execute

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

PL/SQL Collections and Records

Restrictions on BULK COLLECTThe 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 … supported in client-side programs. All targets in a BULK COLLECT INTO clause must be collections, as the … emp.sal%TYPE;

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

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, 9i Release 2 (9.2.0.2)

Native Dynamic SQL

Syntax for Dynamic Bulk BindsBulk binding lets Oracle bind a variable in a SQL statement to a collection of values. The … dynamic bulk binds: EXECUTE IMMEDIATE, FETCH, and FORALL. Bulk EXECUTE IMMEDIATE This statement lets … you bulk-bind define variables or OUT bind arguments passed as parameters to a dynamic SQL statement … . The syntax

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

Native Dynamic SQL

Examples of Dynamic Bulk BindsYou 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 … empno, ename FROM emp'; FETCH emp_cv BULK COLLECT INTO empnos, enames; CLOSE emp_cv; EXECUTE … IMMEDIATE 'SELECT sal

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

Loading Spatial Data

3.1.1 Bulk Loading SDO_GEOMETRY Objectsin Example 2-1 in Section 2.1. Example 3-1 Control File for Bulk Load of Cola Market Geometries … 3-2 shows the control file for loading the data. Example 3-2 Control File for Bulk Load of Polygons

Pro*C/C++ Programmer's Guide, 9i Release 2 (9.2.0.2)

ANSI Dynamic SQL

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

Pro*COBOLĀ® Programmer's Guide, 9i Release 2 (9.2.0.2)

ANSI Dynamic SQL

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

Administrator's Guide, 9i Release 2 (9.2.0.2)

Syntax for LDIF and Command-Line Tools

Bulk Operations Command-Line Tools6.0. Visit: http://www.datafocus.com/products/ Note: All bulk tools require you to enter the correct password in order to access the ods database.

Advanced Replication, 9i Release 2 (9.2.0.2)

Troubleshooting Replication Problems

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

Objects for OLE, 9i Release 2 (9.2.0.2)

Using the PL/SQL Bulk Collect Feature

Using the PL/SQL Bulk Collect FeatureFeedback Using the PL/SQL Bulk Collect Feature This feature enables the selecting bulk of data in single … explaining PL/SQL bulk collection features using OraCollection interface. Set OraDatabase … ENAME bulk collect into:ENAMES from emp; END;") 'here OraParameter object returns EnameList

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

Tuning PL/SQL Applications

Tuning PL/SQL Performance with Bulk BindsLOOP; END; In such cases, if the SQL statement affects four or more database rows, the use of bulk … references a collection, incorporate the BULK COLLECT clause. If possible, use host arrays to pass … dependencies. For more information about bulk binding, see "Reducing Loop Overhead for Collections with Bulk Binds".

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

PL/SQL Collections and Records

Examples of Bulk Fetching from a CursorInto One or More Collections You can bulk-fetch from a cursor into one or more collections: DECLARE … SELECT ename, sal FROM emp WHERE sal > 1000; names NameList; sals SalList; BEGIN OPEN c1; FETCH c1 BULK … COLLECT INTO names, sals; END; Into a Collection of Records You can bulk-fetch from a cursor into a … c1 IS SELECT deptno,

Administrator's Guide, 9i Release 2 (9.2.0.2)

Migrating Local or External Users to Enterprise Users

Overview of the Bulk User Migration ProcessBulk user migration is a two-phase process. In phase one, you start the migration process by

Heterogeneous Connectivity Administrator's Guide, 9i Release 2 (9.2.0.2)

Using Heterogeneous Services Agents

Optimizing Data Transfers Using Bulk FetchWhen an application fetches data from a non-Oracle system using Heterogeneous Services, data is transferred: From the non-Oracle system to the agent process From the agent process to the Oracle database server From the Oracle database server to the application Oracle allows you to optimize all three data transfers, as illustrated in FigureĀ 4-1. Figure 4-1 Optimizing data transfers Text description

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

PL/SQL Collections and Records

How Do Bulk Binds Improve Performance?process known as bulk binding. If the collection has 20 elements, bulk binding lets you perform the … . With bulk binds, entire collections, not just individual elements, are passed back and forth. To do … bulk binds with INSERT, UPDATE, and DELETE statements, you enclose the SQL statement within a PL/SQL … FORALL

Administrator's Guide, 9i Release 2 (9.2.0.2)

Managing Directory Entries

Managing Entries by Using Bulk ToolsThis section lists and describes some of the more common tasks you perform with bulk tools. This

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

PL/SQL Collections and Records

Using FORALL and BULK COLLECT TogetherYou can combine the BULK COLLECT clause with a FORALL statement, in which case, the SQL engine bulkBULK COLLECT INTO enums; The column values returned by each execution are added to the values … ... BULK COLLECT statement in a FORALL statement. Otherwise, you get the error implementation … restriction: cannot

Administrator's Guide, 9i Release 2 (9.2.0.2)

Globalization Support in the Directory

Using Globalization Support with Bulk Toolsthe argument you use for each of the following bulk tools: Using Globalization Support with bulkload … Globalization Support with bulkmodify See Also: "Bulk Operations Command-Line Tools" for a list of arguments for each bulk tool