with
  tbl
    as(
        select '437,00|307,30       ' price, '307,30' rslt  , 1    is_action from dual union all -- есть акция
        select '254,5|329,5          '        , '329,50'       , 1                 from dual union all -- есть акция
        select '1 724                   '        , '1724,00'     , null              from dual union all
        select '855,50                 '         , '855,50'      , null              from dual union all
        select '156.99                 '         , '156,99'      , null              from dual union all
        select '1906                    '         , '1906,00'    , null              from dual union all
        select '724,00руб.            '         , '724,00'     , null              from dual union all
        select '122900руб             '        , '122900,00' , null              from dual union all
        select '55,90руб.46,90руб. '        , '55,90'       , null              from dual union all
        select '306.-                    '        , '306,00'      , null              from dual)
  select * from tbl