Name
replace — This replaces every occurrence of the second argument in the first argument with the third argument.
Synopsis
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 24.317. Example:
SQL> select replace ('12345512345', '23', '-----');
= 1-----4551-----45