|Oracle9i SQL Reference
Release 2 (9.2)
Part Number A96540-01
Functions, 102 of 177
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 datatypes
NCLOB. The string returned is of
VARCHAR2 datatype and is in the same character set as
This function 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 "J" with "BL":