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!
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!