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 COLLECT


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


SQL Reference, 10g Release 1 (10.1)

COLLECT

COLLECTSyntax collect::= Description of the illustration collect.gif Purpose COLLECT takes as its argument … collection, then the output of COLLECT is a nested table of collections. See Also: CAST Examples The … oe.customers: CREATE TYPE phone_book_t AS TABLE OF phone_list_typ; / SELECT CAST(COLLECT(phone_numbers) AS phone_book_t)

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

Packages and Types Reference, 10g Release 1 (10.1)

100 DBMS_TRACE

Creating Database Tables to Collect DBMS_TRACE OutputYou must create database tables into which the DBMS_TRACE package writes output. Otherwise, the data is not collected. To create these tables, run the script TRACETAB.SQL. The tables this script creates are owned by SYS.

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

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

7 Performance Tuning

7.7.3 Should I collect statistics on my tables?Answer: Yes. Collecting statistics on your tables enables Oracle Text to do cost-based analysis. This helps Oracle Text choose the most efficient execution plan for your queries. See Also: "Optimizing Queries with Statistics" in this chapter.

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

20 General Management of Schema Objects

Using DBMS_STATS to Collect Table and Index Statisticsgathering optimizer statistics, but you must use the ANALYZE statement to collect statistics unrelated

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)COLLECT clause brings back batches of results from SQL. If the DML statement affects four or more … FORALL statement instead of a loop construct. To speed up SELECT statements, include the BULK COLLECT

Error Messages, 10g Release 1 (10.1)

14 ORA-19400 to ORA-24276

ORA-23345: table " string "." string " not registered to collect statisticsconflict. Action: Register a named constraint for the specified table. ORA-23345: table " string "." string " not registered to collect statistics

Error Messages, 10g Release 1 (10.1)

7 ORA-07500 to ORA-09859

ORA-09834: snyGetPortSet: failed to collect info on a port.Oracle support. ORA-09834: snyGetPortSet: failed to collect info on a port.

Error Messages, 10g Release 1 (10.1)

36 PLS-00049 to PLS-01913

PLS-00432: implementation restriction: cannot use FORALL and BULK COLLECT INTO together in SELECT statementsinteger datatype. PLS-00432: implementation restriction: cannot use FORALL and BULK COLLECT INTO together in SELECT statements

Error Messages, 10g Release 1 (10.1)

14 ORA-19400 to ORA-24276

ORA-22957: NULL is an invalid input to powermultiset and COLLECT functionsas input ORA-22957: NULL is an invalid input to powermultiset and COLLECT functions

Packages and Types Reference, 10g Release 1 (10.1)

91 DBMS_SQLTUNE

SELECT_WORKLOAD_REPOSITORY Functions: Collect SQL statements from all snapshots between begin_snap and end_snap. Collect SQL statements from a workload repository baseline.

Packages and Types Reference, 10g Release 1 (10.1)

104 DBMS_UTILITY

Usage NotesUse this procedure to collect nonoptimizer statistics. For optimizer statistics, use the DBMS_STATS. GATHER_TABLE_STATS or DBMS_STATS. GATHER_INDEX_STATS procedure.

Packages and Types Reference, 10g Release 1 (10.1)

100 DBMS_TRACE

Operational NotesControlling Data Volume Creating Database Tables to Collect DBMS_TRACE Output Collecting Trace Data Collected Data Trace Control

Advanced Replication Management API Reference, 10g Release 1 (10.1)

PURGE_STATISTICS Procedure

Exceptionsschema does not exist. missingobject Specified table does not exist. statnotreg Table not registered to collect statistics.

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

18 Collections

18.4.3 COLLECTION RESETSQL [AT [:]database] COLLECTION RESET:collect [ [INDICATOR]:collect_ind]. Variables collect (IN/OUT

Oracle® Net Services Reference Guide, 10g Release 1 (10.1)

2 Oracle Connection Manager Control Utility

SET CONNECTION_STATISTICSPurpose Use the SET CONNECTION_STATISTICS command to specify whether gateway processes collect … ]: Specify to have gateway processes collect connection statistics [no]: (Default) Specify that gateway … processes not collect connection statistics Usage Notes If SET CONNECTION_STATISTICS is set to yes

Advanced Replication Management API Reference, 10g Release 1 (10.1)

CANCEL_STATISTICS Procedure

Exceptionsschema does not exist. missingobject Specified table does not exist. statnotreg Specified table is not currently registered to collect statistics.

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 … COLLECT INTO empnos, enames; CLOSE emp_cv; EXECUTE IMMEDIATE 'SELECT sal FROM emp' BULK COLLECT INTO … sals;