Syntax: REPLACE (, [,])
SQL> SQL> SQL> SELECT REPLACE ('ABCDA', 'A','*') replace_A from dual; REPLACE_A -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------- *BCD* SQL>