SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Unique Or Distinct ?

696393May 15 2009 — edited May 15 2009

Hi Guy's,

I have one small doubt :) .. pls help

What is the diffrence between these query's.The out put is similer for both of them....are they same ? if yes Y do we requried duplicate functions?

select unique object_type from user_objects

select distinct object_type from user_objects

thanks,
raj

This post has been answered by Christian Balz on May 15 2009

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 12 2009

Added on May 15 2009

5 comments

2,419 views