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

Can we join more than 2 tables in sql?

958

What does inner join mean?

1076

What are the two types of exceptions.

1115

What are the advantages of pl sql?

1078

What is nosql example?

978

What are the benefits of pl sql?

1068

Does inner join remove duplicates?

902

hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews

1988

What is consistency?

1073

Does truncate require commit?

925

Does sql between include endpoints?

959

What is data profiling in sql?

1024

Is sql harder than python?

1046

How do I run a program in pl sql?

963

Can I copy :old and :new pseudo-records in/to an oracle stored procedure?

1157