Re: select statement as per the column content

[Phillip Ward]

If you want to retrieve ...

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

... then store it as such.

Move the job of "breaking up" that delimited string into the "load" process, with an insert for each [sub-]part.

insert into ABC_MASTER values ( 123, 'abc' ); 
insert into ABC_MASTER values ( 123, 'cvbsmdm' ); 
insert into ABC_MASTER values ( 123, 'cbdjdk(9)' ); 
insert into ABC_MASTER values ( 123, 'asdre-01' );

Working with delimited data is notoriously slow in most databases.

Regards, Phill W.