OraQA

DISTINCT and UNIQUE are synonymous. For example:

SELECT DISTINCT object_type
    FROM user_objects;

is the same as:

SELECT UNIQUE object_type
    FROM user_objects

Resources:

• Documentation
• OTN Forum

Filed under SQL. Follow any responses to this entry through this RSS 2.0 feed.