replace
This replaces every occurrence of the second argument in the first argument
with the third argument.
string replace
(in string varchar,
in what varchar,
in repl_with varchar);
Description
This replaces every occurrence of the second argument in the first argument
with the third argument. The arguments can be narrow or wide strings.
Example:
SQL> select replace ('12345512345', '23', '-----');
= 1-----4551-----45