Finding dup columns in 1 record

I have a ( poorly designed )table that can have multiple duplicates in each column per record. I've tried some nested loops using PL/SQL but I ran into concurrency problems where it would find a duplicate pair 2 times.

Would the better solution be to fetch everything into a PL/SQL table then output the update SQL that way after finding the duplicates? That way I could write the update SQL and also update the PL/SQL table via array assignments so it wouldn't find the same duplicates again and again...

TIA,
Cliff

       The contents of this message express only the sender's opinion.
       This message does not necessarily reflect the policy or views of
       my employer, Merck & Co., Inc.  All responsibility for the statements
       made in this Usenet posting resides solely and completely with the
       sender.