select str as "Котлеты с мухами",
       translate(str, '$1234567890', '$') as "Мухи",
       translate(str, '1234567890'||translate(str, '$1234567890', '$'), '1234567890') as "Котлеты"
  from (
          select '45А' as str from dual union all
          select '3/В' as str from dual union all
          select '345' as str from dual union all
          select 'dgВ' as str from dual union all
          select '2-б' as str from dual
       )

Query finished, retrieving results...

Котлеты с мухами  Мухи  Котлеты
----------------  ----  -------
45А               А           45 
 3 /В               /В           3 
 345                           345 
dgВ               dgВ
 2 -б               -б           2 

 3  row(s) retrieved