char with every occurrence of
search_string replaced with
replacement_string is omitted or null, then all occurrences of
search_string are removed. If
search_string is null, then
char is returned.
replacement_string, as well as
char, can be any of the data types
NCLOB. The string returned is in the same character set as
char. The function returns
VARCHAR2 if the first argument is not a LOB and returns
CLOB if the first argument is a LOB.
REPLACE provides functionality related to that provided by the
TRANSLATE provides single-character, one-to-one substitution.
REPLACE lets you substitute one string for another as well as to remove character strings.
Appendix C in Oracle Database Globalization Support Guide for the collation determination rules, which define the collation
REPLACEuses to compare characters from
charwith characters from
search_string, and for the collation derivation rules, which define the collation assigned to the character return value of this function
The following example replaces occurrences of
SELECT REPLACE('JACK and JUE','J','BL') "Changes" FROM DUAL; Changes -------------- BLACK and BLUE