For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
How can I use regexp_replace to remove a dots '.' From a string
create table t (nm varchar2(20)); insert into t values ('.0.0.0.1'); insert into t values ('10.0.1.1.0'); commit; Desired results select * from t; NM 0001 100110