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!

Remove duplicates in string without sorting(do not change the order)

Gor_MahiaApr 28 2022

All,
Ive strings like below and i want to remove duplicates without changing the sort order (so listagg might not work for me even with random() order clause)
sample:
i. terry@gmail.com, owen@gmail.com,Scotto@yahoo.com,terry@gmail.com, Atieno@gmail.com,Scotto@yahoo.com

and correct output should be (remember dont change the order):
i. terry@gmail.com, owen@gmail.com,Scotto@yahoo.com, Atieno@gmail.com
oracle 11.x g,
thanks

This post has been answered by Solomon Yakobson on Apr 28 2022

Jump to Answer

Added on Apr 28 2022

#plsql, #sql

6 comments

503 views