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