Skip to Main Content

SQL & PL/SQL

Announcement

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!

REGEXP_REPLACE leading and trailing whitespace

RengudiAug 12 2022

Hi
I want to remove leading and trailing whitespace from the string also \t and \n have to replace with white space using regexp_replace options
select ( ' blln01-mdb1\t-cp-pxtr1-h\ni1<-->glln01-mdb1-rcb-gw1\u00a0 ') from dual;

Thanks!

Comments
Post Details
Added on Aug 12 2022
2 comments
3,936 views