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.
Example24.317.Example:
SQL> select replace ('12345512345', '23', '-----'); = 1-----4551-----45