hi
I want to regex_replace to below-expected result
input:-
with
t as(select '2001:520:4:e402/128' from dual
union
select '2001:720:4:f402/64' from dual
union
select '2001:820:4:g402:/1024' from dual
union
select '10.1.1.1/64' from dual
union
select '2001:820:4:h402::/256' from dual
union
select '2001:920:4:i502:::/128' from dual
)
select * from t;
Expected result:-
2001:520:4:e402::/128
2001:720:4:f402::/64
2001:820:4:g402::/1024
10.1.1.1/64
2001:820:4:h402::/256
2001:920:4:i502::/128