How to replace specific character in String in Oracle

Published on

Suppose if the string contains unwanted character that is to be removed or replace For Example            [howwhywhat.in] The square brackets are junk character here . so we need to remove it while returning query result. Solution    select regexp_replace(‘[howwhywhat.in]’, ‘[\[\]]’, ‘ ‘) from dual;     select translate(‘[howwhywhat.in]’, ‘[\[\]]’, ‘ ‘) … Continue reading How to replace specific character in String in Oracle