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 type Normalizer as object (
    tokens tokenList,
    member procedure split (str varchar2, pattern char), -- return tokenList,
    not instantiable member procedure normalize (rmpatt char),
    member function join (delimiter char := '; ') return varchar2
) not instantiable not final
/
create or replace type NormalizePhone under Normalizer (
    constructor function NormalizePhone (
        str varchar2, splitpatt char, rmpatt char) return self as result,
    overriding member procedure normalize (rmpatt char) -- return tokenList,
) instantiable final
/
create or replace type body Normalizer as
    member procedure split (str varchar2, pattern char) is
        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;
            self.tokens.extend;
            self.tokens(tokens.last) := s;
        end loop;
    end split;
    member function join (delimiter char := '; ') return varchar2 is
        ret varchar2 (32767);
    begin
        for i in 1..self.tokens.count loop 
            ret := ret||tokens(i)||delimiter; end loop;
        return rtrim (ret, delimiter);
    end join;
end;
/
create or replace type body NormalizePhone as
    constructor function NormalizePhone (
        str varchar2, splitpatt char, rmpatt char) return self as result is
    begin
        self.tokens := tokenList(); 
        self.split (str, splitpatt);
        normalize (rmpatt);
        return;
    end;
    overriding member procedure normalize (rmpatt char) is
    begin 
        for i in 1..self.tokens.count loop
            self.tokens(i) := regexp_replace (self.tokens(i), rmpatt);
        end loop;
    end;
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 NormalizePhone (col, splitpatt, rmpatt).join();
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