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!

how to delete duplicate values from comma separated string

2196b809-8b42-4c19-8a45-f678a8b31d7bSep 2 2015 — edited Sep 3 2015


Hi All,

I have a requirement to delete duplicate from comma separated string:

here is sample code (actual data may be in million)

{code}

create table test_dup_del (num number(10), dup_val varchar2(100));              

insert into test_dup_del values(1234,'1, 2, 3, 4, 3, 1');
insert into test_dup_del values(4567,'1, 2, 2, 4, 4, 1');
insert into test_dup_del values(7894,'1, 2, 1, 3, 3, 1');
insert into test_dup_del values(1478,'1, 2, 4, 4, 3, 2');
insert into test_dup_del values(2589,'1, 2, 1, 2, 1, 2');
commit;

(code}

my output would be :

1234,'1, 2, 3, 4'

4567,'1, 2, 4'

7894,'1, 2, 3'

1478,'1, 2, 3, 4'

2589,'1, 2'

Thanks,

Raaz

This post has been answered by BluShadow on Sep 2 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 30 2015
Added on Sep 2 2015
9 comments
1,970 views