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
COLLECT → Syntax 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)
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
Creating Database Tables to Collect DBMS_TRACE Output → You 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.
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
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.
Using DBMS_STATS to Collect Table and Index Statistics → gathering optimizer statistics, but you must use the ANALYZE statement to collect statistics unrelated
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) → 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
ORA-23345: table " string "." string " not registered to collect statistics → conflict. Action: Register a named constraint for the specified table. ORA-23345: table " string "." string " not registered to collect statistics
ORA-09834: snyGetPortSet: failed to collect info on a port. → Oracle support. ORA-09834: snyGetPortSet: failed to collect info on a port.
PLS-00432: implementation restriction: cannot use FORALL and BULK COLLECT INTO together in SELECT statements → integer datatype. PLS-00432: implementation restriction: cannot use FORALL and BULK COLLECT INTO together in SELECT statements
ORA-22957: NULL is an invalid input to powermultiset and COLLECT functions → as input ORA-22957: NULL is an invalid input to powermultiset and COLLECT functions
SELECT_WORKLOAD_REPOSITORY Functions → : Collect SQL statements from all snapshots between begin_snap and end_snap. Collect SQL statements from a workload repository baseline.
Usage Notes → Use this procedure to collect nonoptimizer statistics. For optimizer statistics, use the DBMS_STATS. GATHER_TABLE_STATS or DBMS_STATS. GATHER_INDEX_STATS procedure.
Operational Notes → Controlling Data Volume Creating Database Tables to Collect DBMS_TRACE Output Collecting Trace Data Collected Data Trace Control
Exceptions → schema does not exist. missingobject Specified table does not exist. statnotreg Table not registered to collect statistics.
18.4.3 COLLECTION RESET → SQL [AT [:]database] COLLECTION RESET:collect [ [INDICATOR]:collect_ind]. Variables collect (IN/OUT
SET CONNECTION_STATISTICS → Purpose 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
Exceptions → schema does not exist. missingobject Specified table does not exist. statnotreg Specified table is not currently registered to collect statistics.
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 … COLLECT INTO empnos, enames; CLOSE emp_cv; EXECUTE IMMEDIATE 'SELECT sal FROM emp' BULK COLLECT INTO … sals;