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