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