Results for DISTINCT


1 to 20 of 401 results. Prev  Next
Results per page:   20  | 40 | 60


SQL Reference, 9i Release 2 (9.2.0.2)

Oracle Reserved Words

DISTINCT *DROP * ELSE *

Application Developer's Guide - Large Objects, 9i Release 2 (9.2.0.2)

LOB Support in Different Programmatic Environments

Distinct Classes for Each LOB TypeUnlike OCI which uses a common API for operations on BLOBs, CLOBs, and BFILEs, OCCI has distinct

Enterprise Manager Database Tuning with the Oracle Tuning Pack, 9i Release 2 (9.2.0.2)

Gathering and Analyzing Information

Distinct ValuesNumber of unique values in the column.

Error Messages, 9i Release 2 (9.2.0.2)

ORA-00900 to ORA-01499

ORA-01415 too many distinct aggregate functionsCause: The query contains more distinct aggregates than can be processed. The current limit is 255 … . Action: Reduce the number of distinct aggregate functions in the query.

Error Messages, 9i Release 2 (9.2.0.2)

PL/SQL and FIPS Messages (PLS)

PLS-01471 The keyword DISTINCT must be present in a COUNT(DISTINCT sim_expr)Cause: The keyword DISTINCT must be present in a COUNT(DISTINCT sim_expr). Action: Refer to ANSI document ANSI X3.135-1992 for details.

Error Messages, 9i Release 2 (9.2.0.2)

Summary Advisor, Explain Rewrite, and Explain Materialized View Messages (QSM)

QSM-02084 DISTINCT clause on a duplicate sensitive aggregate functionCause: The capability in question is not supported when the materialized view uses the DISTINCT … clause in this context. Action: Re-phrase the query to avoid the use of the DISTINCT clause.

Error Messages, 9i Release 2 (9.2.0.2)

Summary Advisor, Explain Rewrite, and Explain Materialized View Messages (QSM)

QSM-02002 DISTINCT aggregate measure in SELECT listCause: The capability in question is not supported when the materialized view uses the DISTINCT … qualifier on an aggregate function. Action: Remove the DISTINCT qualifier.

Error Messages, 9i Release 2 (9.2.0.2)

Summary Advisor, Explain Rewrite, and Explain Materialized View Messages (QSM)

QSM-02054 DISTINCT clause in select list in materialized viewCause: The capability in question is not supported when the materialized view uses the DISTINCT … clause in the select list. Action: Re-phrase the query to avoid the use of the DISTINCT clause.

Error Messages, 9i Release 2 (9.2.0.2)

ORA-12700 to ORA-19399

ORA-14011 names assigned to resulting partitions must be distinctdistinct. Action: Rename resulting partition(s) to ensure that their names are distinct and

Error Messages, 9i Release 2 (9.2.0.2)

ORA-12700 to ORA-19399

ORA-13347 the coordinates defining an arc are not distinctof the arc, ensuring that three distinct coordinate values are used.

Error Messages, 9i Release 2 (9.2.0.2)

PL/SQL and FIPS Messages (PLS)

PLS-01472 In a set_function_specification, if DISTINCT is present, the expression must be a column_specificationCause: In a set_function_specification, if DISTINCT is present, the expression must be a

Error Messages, 9i Release 2 (9.2.0.2)

ORA-29250 to ORA-32799

ORA-30480 DISTINCT option not allowed with GROUP BY CUBE or ROLLUPORA-30481 GROUPING function only supported with GROUP BY CUBE or ROLLUP

Error Messages, 9i Release 2 (9.2.0.2)

ORA-00900 to ORA-01499

ORA-01446 cannot select ROWID from view with DISTINCT, GROUP BY, etc.Cause: A SELECT statement attempted to select ROWIDs from a view containing columns derived from functions or expressions. Because the rows selected in the view do not correspond to underlying physical records, no ROWIDs can be returned. Action: Remove ROWID from the view selection clause, then re-execute the statement.

Error Messages, 9i Release 2 (9.2.0.2)

ORA-01500 to ORA-02099

ORA-02014 cannot select FOR UPDATE from view with DISTINCT, GROUP BY, etc.functions, SELECT DISTINCT, CONNECT BY clause, or set operation, UNION, INTERSECT, or MINUS. Action: Do not use SELECT... FOR UPDATE on this view.

Error Messages, 9i Release 2 (9.2.0.2)

ORA-00900 to ORA-01499

ORA-01472 cannot use CONNECT BY on view with DISTINCT, GROUP BY, etc.and rows of the underlying table. Action: Remove the DISTINCT or GROUP BY from the view or move the CONNECT BY clause into the view.

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

OCI Cartridge Functions, 26 of 43

numkeys (OUT)The number of distinct keys stored in memory.

Reference, 9i Release 2 (9.2.0.2)

CONTAINS Query Operators

NotesEach hierarchy in a thesaurus represents a distinct, separate branch, corresponding to the four

Data Warehousing Guide, 9i Release 2 (9.2.0.2)

Logical Design in Data Warehouses

Unique IdentifiersUnique identifiers are specified for one distinct record in a dimension table. Artificial unique

Application Developer's Guide - Large Objects, 9i Release 2 (9.2.0.2)

Modeling and Design

SQL Features Where LOBs Cannot be Usedbe Used   SQL Feature Example for CLOB Columns SELECT DISTINCT SELECT DISTINCT clobCol from

SQL Reference, 9i Release 2 (9.2.0.2)

Operators, 5 of 6

Set Operatorsselected 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





Was this page helpful?

Integrated Cloud Applications & Platform Services