Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production

SQL> variable txt varchar2(1000);
SQL>
SQL> exec :txt := 'BF LOIN NY STYLE SIRLOIN D3400-S9-I1347,D3300-S9-I1347,D3600-S9-I1347,D3800-S9-I1347,D3900-S9-I1347,D4200-S9-I134
7';

PL/SQL procedure successfully completed.

SQL>
SQL> set linesize 90
SQL> column token format a40
SQL> column val format a40
SQL>
SQL> with data as(
  2  select
  3  trim( substr (txt,
  4  instr (txt, ',', 1, level ) + 1,
  5  instr (txt, ',', 1, level+1)- instr (txt, ',', 1, level) -1 ) ) as token
  6   from (select ','||:txt||',' txt
  7   from dual)
  8   connect by level <=
  9   length(:txt)-length(replace(:txt,',',''))+1 )
 10  select token, substr(token, 2, instr(token, '-')-2) val from data;

TOKEN                                    VAL
---------------------------------------- ----------------------------------------
BF LOIN NY STYLE SIRLOIN D3400-S9-I1347  F LOIN NY STYLE SIRLOIN D3400
D3300-S9-I1347                           3300
D3600-S9-I1347                           3600
D3800-S9-I1347                           3800
D3900-S9-I1347                           3900
D4200-S9-I1347                           4200

6 rows selected.

SQL>SQL> exec :txt := replace('BF LOIN NY STYLE SIRLOIN D3400-S9-I1347,D3300-S9-I1347,D3600-S9-I1347,D3800-S9-I1347,D3900-S9-I1347,D4200-S9-I1347', ' ', ',');

PL/SQL procedure successfully completed.

SQL> with data as(
  2  select
  3  trim( substr (txt,
  4  instr (txt, ',', 1, level ) + 1,
  5  instr (txt, ',', 1, level+1)- instr (txt, ',', 1, level) -1 ) ) as token
  6   from (select ','||:txt||',' txt
  7   from dual)
  8   connect by level <=
  9   length(:txt)-length(replace(:txt,',',''))+1 )
 10  select X.val from (select token, substr(token, 2, instr(token, '-')-2) val from data)X
 11   where X.val is not null;

VAL
----------------------------------------
3400
3300
3600
3800
3900
4200

6 rows selected.

SQL>