Skip to Main Content

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!

Duplicate Value In Multiple Columns Of Same Row

ponicpoolFeb 20 2018 — edited Feb 20 2018

Hello,

How can I find out a duplicate value in multiple columns exist of the same row in a table?

E.g. I have column value ABXYZ in multiple columns of the same row. How do I find the same value (ABXYZ) exist of the same row?

P.S. I am using a primitive Oracle database which is Oracle 8i

Appreciate any help

This post has been answered by Gaz in Oz on Feb 20 2018
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 20 2018
Added on Feb 20 2018
20 comments
1,611 views