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