replace
This replaces every occurrence of the second argument in the first argument
with the third argument.
(
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
