with m as (
   select '999\-999\-99\-99' mask, '4959009876' num from dual union all
           select '\9\-\8\-9999999999\;' mask, '4959009876' num from dual union all
           select '\+\7\(999\)999\-99\-99\;\1', '4959009876' num from dual)
     , m1 as (select num, replace(mask, '\9','\'||chr(1)) mask from m)
     , fmt as (select num
                    , rtrim(ltrim(replace(regexp_replace(' '||m1.mask, '(^9|[^9]|$)+',')('),'9','.'),')'),'(') mask_str
                    , listagg(txt,'') within group(order by lvl) format_str
                 from m1
                    , (select level lvl
                            , mask --для нескольких строк источника
                            , replace(replace(ltrim(regexp_substr(' '||mask,'(^9|[^9])+',1, level),'\9'),chr(1),'9'),'\')||'\'||level txt
                         from m1
                      connect by regexp_substr(' '||mask,'(^9|[^9])+',1, level) is not null 
                        and mask=prior mask and prior dbms_random.value is not null --для нескольких строк источника
                      ) a
                where m1.mask = a.mask --для нескольких строк источника
                group by m1.mask, num
              )
select phone_num from (              
select regexp_replace(num, mask_str, format_str) phone_num from fmt)
;