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
7.2.2 Using the distinct Method → You use the distinct method to produce a Source that does not have any duplicated values. Example 7 … the descendants includes the ancestor value, the example uses the distinct method to remove the … removing any duplicate elements with the distinct method. Example 7-2 Using the distinct Method Source … ).distinct();
Restrictions on DISTINCT and UNIQUE Queries → When you specify DISTINCT or UNIQUE, the total number of bytes in all select list expressions is … parameter DB_BLOCK_SIZE. You cannot specify DISTINCT if the select_list contains LOB columns. ALL
1.1.1 Problems Maintaining Two Distinct Systems → The integration of multidimensional technology in a relational database is important because maintaining a standalone multidimensional database is costly. It requires additional hardware and DBAs who are skilled at using the specialized administrative tools of the multidimensional database. Moreover, standalone multidimensional databases require applications that use proprietary APIs. This severely
ORA-01415: too many distinct aggregate functions → maximum array length. Action: Sepcify a valid length. ORA-01415: too many distinct aggregate functions
PLS-01471: The keyword DISTINCT must be present in a COUNT(DISTINCT sim_expr) → … Action: none PLS-01471: The keyword DISTINCT must be present in a COUNT(DISTINCT sim_expr)
ORA-13347: the coordinates defining an arc are not distinct → … Action: Alter the definition of the arc, or set the SDO_ETYPE or SDO_GTYPE to the line type. ORA-13347: the coordinates defining an arc are not distinct
QSM-02054: DISTINCT clause in select list in mv → subquery. Action: Re-phrase the query to avoid the use of collection subqueries. QSM-02054: DISTINCT clause in select list in mv
ORA-14011: names assigned to resulting partitions must be distinct → the list of physical attributes of an index partition ORA-14011: names assigned to resulting partitions must be distinct
QSM-02084: DISTINCT clause on a duplicate sensitive aggregate function → : DISTINCT clause on a duplicate sensitive aggregate function
QSM-02002: DISTINCT aggregate measure in SELECT list → container table. Action: Recreate the materialized view using a conventional container table. QSM-02002: DISTINCT aggregate measure in SELECT list
ORA-40108: input data contains too few distinct target ( string ) values → option and retry the operation. ORA-40108: input data contains too few distinct target ( string ) values
PLS-01472: In a set_function_specification, if DISTINCT is present, the expression must be a column_specification → Cause: The keyword DISTINCT must be present in a COUNT(DISTINCT sim_expr). Sect 5.8 Action: none … PLS-01472: In a set_function_specification, if DISTINCT is present, the expression must be a column_specification
numkeys (OUT) → The number of distinct keys stored in memory.
Navigational Features → home page help you organize management tasks into distinct categories; for example, click Maintenance
The ALL_ROWS hint explicitly chooses the query optimization approach to optimize a statement block with… → RULE The RULE hint disables the use of the query optimizer. This hint is unsupported and should not be used. rule_hint::= Text description of the illustration rule_hint.gif
nested tables XMLType Unsupported Tables, Sequences, and Views Most schemas that ship with the Oracle… → 220.127.116.11 Skipped SQL Statements on a Logical Standby Database By default, all SQL statements except those in the following list are applied to a logical standby database if they are executed on a primary database:
Operator Returns → selected by either query, including all duplicates INTERSECT All distinct rows selected by both … queries MINUS All distinct rows selected by the first query but not the second
SQL Functions → NUMBER; emp_count NUMBER; BEGIN SELECT COUNT(DISTINCT job_id) INTO job_count FROM employees; SELECT COUNT(*) INTO emp_count FROM employees; END; /
Unique Identifiers → Unique identifiers are specified for one distinct record in a dimension table. Artificial unique
Unsupported Use of LOBs in SQL → of LOBs in SQL SQL Operations Not Supported Example of unsupported usage SELECT DISTINCT SELECT … DISTINCT clobCol from... SELECT clause ORDER BY SELECT... ORDER BY clobCol SELECT clause GROUP BY SELECT