Oracle 18c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select * from V$VERSION;


BANNER
BANNER_FULL
BANNER_LEGACY
CON_ID


Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production
Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production
Version 18.4.0.0.0
Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production
0


create or replace type tokenList force is table of varchar2 (32767)
/
create or replace package packNormalizer as 
    function split (str varchar2, pattern char) return tokenList;
    function normalize (tl tokenList, rmpatt char) return tokenList;
    function join (tokens tokenList, delimiter char := '; ') return varchar2;
end;
/
create or replace package body packNormalizer as
    function split (str varchar2, pattern char) return tokenList is
        tokens tokenList := tokenList ();
        s varchar2(96);
        c int := 0;
    begin
        <<split>> loop c := c + 1;
            s := regexp_substr (str, pattern, 1, c, null, 1);
            exit split when s is null;
            tokens.extend;
            tokens(tokens.last) := s;
        end loop;
        return tokens;
    end split;
    function normalize (tl tokenList, rmpatt char) return tokenList is
        tokens tokenList := tl;
    begin 
        for i in 1..tokens.count loop
            tokens(i) := regexp_replace (tokens(i), rmpatt);
        end loop;
        return tokens;
    end; 
    function join (tokens tokenList, delimiter char := '; ') return varchar2 is
        ret varchar2 (32767);
    begin
        for i in 1..tokens.count loop ret := ret||tokens(i)||delimiter; end loop;
        return rtrim (ret, delimiter);
    end join;
end;
/
create table normalizerconf (tabname, colname, ty, splitpatt, rmpatt) as
    select 'data1', 'col1', 'phone', '(.*?)((,\s+)|($))', '\D+' from dual  
/
1 rows affected

create table data1 (id, col1) as
    select 1, '123/456789, 032-156789' from dual
/
1 rows affected

with function getphonelist (
    col varchar2, splitpatt varchar2, rmpatt varchar2) return varchar2 is
begin
    return
        packNormalizer.join (
            packNormalizer.normalize (
                packNormalizer.split (col, splitpatt), rmpatt));
end;
select d.col1, getphonelist (col1, splitpatt, rmpatt) result
from data1 d
cross join normalizerconf c
where c.tabname = 'data1' and colname = 'col1'


COL1
RESULT


123/456789, 032-156789
123456789; 032156789