SQL & PL/SQL

Hi,

I need to restructure one of the table to create report in BI.

create table DSW

(sno varchar2(10),

id varchar2(100));

insert into DSW values('101','5|10|120|102|50');

insert into DSW values('102','41|341|225');

insert into DSW values('103','15')

Expected output:

sno          id

101          5

101          10    

101          120

101          102

101          50

102          41

102          341

102          225

103          15

Thanks,

Nawaz