DISTINCT AND UNIQUE are same operation. But, You cannot specify DISTINCT i

Differences between UNIQUE and DISTINCT in select statements

Question Posted / howard cheon

Answer Posted / howard cheon

DISTINCT AND UNIQUE are same operation.
But, You cannot specify DISTINCT if the select_list
contains LOB columns.

Is This Answer Correct ?

16 Yes

16 No

Please Help Members By Posting Answers For Below Questions

How do I save a sql query?

1067

Could you please provide oca (oracle 10g) dumps for my certification ?

5241

What is %rowtype in pl sql?

1030

How do you create a db file?

1067

What is the difference between left join and right join?

987

how to use in conditions? : Sql dba

1060

Why do we need databases?

1086

What are the various restrictions imposed on view in terms of dml?

1017

What is the difference between sql, mysql and sql server?

1174

What are packages in pl sql and also explain its advantages?

1122

what is cross join? : Sql dba

1048

How is debugging done?

1020

how to enter binary numbers in sql statements? : Sql dba

1011

Can we use update in sql function?

1115

What is oracle sql developer?

1118