Hi Howard Cheon, you are currect... but we cant able to use

Differences between UNIQUE and DISTINCT in select statements

Question Posted / vijay mohan reddy

26 Answers
134904 Views
ABS, DELL, Deloitte, Hewitt, Oracle, Verinon Technology Solutions, Wipro, I also Faced
E-Mail Answers

Answer Posted / vijay mohan reddy

Hi Howard Cheon,
you are currect... but we cant able to use
both DISTINCT and UNIQUE, if the select_list contains LOB,
LONG columns. It may not a difference.

Could anyone plz give some another major difference..

Thanks in Advance

Vijay Reddy.

Is This Answer Correct ?

9 Yes

10 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

When is the update_statistics command used?

1061

Which command is used to delete a trigger?

1280

How do you run a query?

967

What is sql catalog?

969

What is memory optimized?

1032

How many parts of a pl sql block are optional?

1055

What is the difference between delete, truncate and drop command?

1084

Does google use sql?

918

What is rowtype?

967

What is substitution variable?

1017

Why do we use function in pl sql?

1028

What is pragma in pl sql?

1050

what are different types of keys in sql?

1086

What is join view in sql?

911

What are the packages in pl sql?

981