|Oracle® Database SQL Language Reference
11g Release 2 (11.2)
Part Number E17118-03
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.
The following example replaces occurrences of
SELECT REPLACE('JACK and JUE','J','BL') "Changes" FROM DUAL; Changes -------------- BLACK and BLUE