ORACLE - Character Functions: Replace
The Replace function of a one character string for another.
Syntax is:
replace (string, character to replace, character replacing)
string1: A string in which to locate the character to replace
character to replace: the character you have to search the string characters and wants to replace it replaces
character is optional: In all places where it detects the existence of a character to replace is replaced by the character included in this parameter, if this parameter is omitted simply be deleted the character detected.
Examples:
replace ('12hola12 ', '12') returns 'hello'
replace ('mundo22', '2 ', '3') return 'mundo33'
replace ('0000123 ', '0') returns '123 '
0 comments:
Post a Comment