with s as (select '205400#120700#133100#134400' value, 0 id from dual
         --union all select '205401#120701#133101#134401' value, 1 id from dual --с этой строкой результат увеличивается до 30 строк
          )
select id, regexp_substr(value, '[^#]+', 1, level) val
from s
connect by instr(value, '#', 1, level - 1) > 0;

select regexp_substr(str,'\d+',1,level) result,
       level,
       str
from (select '9546;9547' str, 1 a from dual
      union all
      select '95406;95407;95499' str, 2 a from dual
     )
connect by regexp_substr(str,'\d+',1,level) is not null
    and prior a = a
    and prior dbms_random.value is not null;