|Oracle® OLAP DML Reference
11g Release 2 (11.2)
Part Number E17122-05
REPLACE provides functionality related to that provided by the TRANSLATE function. TRANSLATE provides single-character, one-to-one substitution. REPLACE lets you substitute one string for another as well as to remove character strings.
See:REPLACE function in Oracle Database SQL Language Reference for more details.
The same data type as char.
REPLACE ( char, search_string [, replacement_string ])
A text expression that is the character that you want returned when a replacement is made.
A text expression that is the string you want to replace. When you specify NA, then the function returns char.
A text expression that is the string with which you want to replace search_string. When you do not specify a value for this argument or when you specify the value of
NA, all occurrences of search_string are removed.