SQL>
Syntax: REPLACE(, [, ])
SQL>
SQL>
SQL> SELECT
2 REPLACE ('ABCDA', 'A','*') replace_A,
3 REPLACE ('ABCDA', 'A') remove_A,
4 REPLACE ('ABCDA',NULL) null_search
5 FROM dual;
REPLA REM NULL_
----- --- -----
*BCD* BCD ABCDA
SQL>
SQL>