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 390 results. Previous page Prev  Next next page
Results per page:   20  | 40 | 60


Developer's Guide to the OLAP API, 10g Release 1 (10.1)

7 Making Queries Using Source Methods

7.2.2 Using the distinct MethodYou 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();

SQL Reference, 10g Release 1 (10.1)

SELECT

Restrictions on DISTINCT and UNIQUE QueriesWhen 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

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

1 Overview

1.1.1 Problems Maintaining Two Distinct SystemsThe 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

Error Messages, 10g Release 1 (10.1)

3 ORA-00910 to ORA-01497

ORA-01415: too many distinct aggregate functionsmaximum array length. Action: Sepcify a valid length. ORA-01415: too many distinct aggregate functions

Error Messages, 10g Release 1 (10.1)

36 PLS-00049 to PLS-01913

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)

Error Messages, 10g Release 1 (10.1)

13 ORA-12700 to ORA-19361

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

Error Messages, 10g Release 1 (10.1)

31 QSM-00501 to QSM-02188

QSM-02054: DISTINCT clause in select list in mvsubquery. Action: Re-phrase the query to avoid the use of collection subqueries. QSM-02054: DISTINCT clause in select list in mv

Error Messages, 10g Release 1 (10.1)

13 ORA-12700 to ORA-19361

ORA-14011: names assigned to resulting partitions must be distinctthe list of physical attributes of an index partition ORA-14011: names assigned to resulting partitions must be distinct

Error Messages, 10g Release 1 (10.1)

31 QSM-00501 to QSM-02188

QSM-02084: DISTINCT clause on a duplicate sensitive aggregate function: DISTINCT clause on a duplicate sensitive aggregate function

Error Messages, 10g Release 1 (10.1)

31 QSM-00501 to QSM-02188

QSM-02002: DISTINCT aggregate measure in SELECT listcontainer table. Action: Recreate the materialized view using a conventional container table. QSM-02002: DISTINCT aggregate measure in SELECT list

Error Messages, 10g Release 1 (10.1)

20 ORA-40001 to ORA-40273

ORA-40108: input data contains too few distinct target ( string ) valuesoption and retry the operation. ORA-40108: input data contains too few distinct target ( string ) values

Error Messages, 10g Release 1 (10.1)

36 PLS-00049 to PLS-01913

PLS-01472: In a set_function_specification, if DISTINCT is present, the expression must be a column_specificationCause: 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

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

Cartridge Services -- Parameter Manager Interface

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

2 Day DBA, 10g Release 1 (10.1)

3 Getting Started with Oracle Enterprise Manager

Navigational Featureshome page help you organize management tasks into distinct categories; for example, click Maintenance

Performance Tuning Guide, 10g Release 1 (10.1)

17 Optimizer Hints

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

Concepts and Administration, 10g Release 1 (10.1)

4 Creating a Logical Standby Database

nested tables XMLType Unsupported Tables, Sequences, and Views Most schemas that ship with the Oracle…4.1.1.1 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:

SQL Reference, 10g Release 1 (10.1)

Set Operators

Operator Returnsselected 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

User's Guide and Reference, 10g Release 1 (10.1)

6 Performing SQL Operations from PL/SQL

SQL FunctionsNUMBER; emp_count NUMBER; BEGIN SELECT COUNT(DISTINCT job_id) INTO job_count FROM employees; SELECT COUNT(*) INTO emp_count FROM employees; END; /

Guide, 10g Release 1 (10.1)

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, 10g Release 1 (10.1)

9 SQL Semantics and LOBs

Unsupported Use of LOBs in SQLof 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