SQL & PL/SQL

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