create or replace function format_colmun(col varchar2)
return varchar2 is
Results varchar2(2000);
begin
Results:=trim(replace(col,translate(col,'#0123456789','#'),''));
return (Results);
end format_colmun;
/
return varchar2 is
Results varchar2(2000);
begin
Results:=trim(replace(col,translate(col,'#0123456789','#'),''));
return (Results);
end format_colmun;
/