select statement as per the column content

[chinmay panda]

Hi All,

Hope you are doing well.

Please find the requirement.

Create table statement
Code: [Select all] [Show/ hide]

create table ABC_MASTER (Part_number varchar(40),Filename varchar(80));

Insert table statement
Code: [Select all] [Show/ hide]
insert into ABC_MASTER values (123, abc*cvbsmdm*cbdjdk(9)*asdre-01);
insert into ABC_MASTER values (124, qwe);

Now the task is the select statement from ABC_MASTER which shows like this, split the string as per (*)

part_number................filename
123............................abc
123............................cvbsmdm
123............................cbdjdk(9)
123............................asdre-01
124............................qwe

Thanks
Chinmay