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
Bulk Array Binds → Bulk selects, inserts, updates, and deletes can enhance the performance of applications by bundling
Using Bulk Dynamic SQL → In 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
Restrictions on BULK COLLECT → The 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;
3.1 Bulk Loading → Bulk loading can import large amounts of ASCII data into an Oracle database. Bulk loading is
Syntax for Dynamic Bulk Binds → Bulk 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
Examples of Dynamic Bulk Binds → 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 … empno, ename FROM emp'; FETCH emp_cv BULK COLLECT INTO empnos, enames; CLOSE emp_cv; EXECUTE … IMMEDIATE 'SELECT sal
3.1.1 Bulk Loading SDO_GEOMETRY Objects → in 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
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
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
Bulk Operations Command-Line Tools → 6.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.
Bulk Updates and Constraint Violations → performs constraint checking at the end of each statement. While a bulk update may not violate a
Using the PL/SQL Bulk Collect Feature → Feedback 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
Tuning PL/SQL Performance with Bulk Binds → LOOP; 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".
Examples of Bulk Fetching from a Cursor → Into 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,
Overview of the Bulk User Migration Process → Bulk user migration is a two-phase process. In phase one, you start the migration process by
Optimizing Data Transfers Using Bulk Fetch → When 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
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
Managing Entries by Using Bulk Tools → This section lists and describes some of the more common tasks you perform with bulk tools. This
Using FORALL and BULK COLLECT Together → You can combine the BULK COLLECT clause with a FORALL statement, in which case, the SQL engine bulk … BULK 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
Using Globalization Support with Bulk Tools → the 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