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 DISTINCT


1 to 20 of 379 results. Previous page Prev  Next next page
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-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)

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)

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)

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)

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)

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-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-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)

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-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 UsedUsed   SQL Feature Example for CLOB Columns SELECT DISTINCT SELECT DISTINCT clobCol from... SELECT

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