Wiki: REPLACE

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: #

Text

Errors: #

None

Example:#

replace(~,'-') will remove all hyphens from the passed string

replace(~,'-','.') will change all hyphens to periods in the passed string.

Notes #

Click to create a new notes page

Screen captures are meant to be indicative of the concept being presented and may not reflect the current screen design.
If you have any comments or questions please email the Wiki Editor