REPLACE#
Functionality:#
This Oracle function will remove characters from within a string.Parameters: #
STRING | The source, or original, string |
SEARCH | The character string that you want to replace |
REPLACE | (optional) The characters that you want to take the place of the characters specified in SEARCH above. If not specified, it will remove the characters specified in SEARCH |
Returns: #
TextErrors: #
NoneExample:#
replace(~,'-') will remove all hyphens from the passed string
replace(~,'-','.') will change all hyphens to periods in the passed string.