REPLACE: Replace with string every time it occurs
SQL> SQL> -- Replace with string every time it occurs. SQL> SQL> SELECT REPLACE ('This is a test',' is ',' may be ') FROM dual; REPLACE('THISISATE ------------------ This may be a test SQL>