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!

Distinct not working in Oracle SQL* Plus

stoneiidolJul 12 2010 — edited Feb 7 2012

Hi all

I just created a script to query unique records in the Oracle SQL Developer. The results when run in Developer are unique but when i tried the script in SQL*Plus, it gives duplicate records. I tried the same script in TOAD and it did give unique records. I am using DISTINCT.

Has anyone come across this problem before? is the problem coming from SQL*Plus or my script.

Thanks alot for your repy

SI

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 6 2012

Added on Jul 12 2010

8 comments

2,243 views