Friday, December 19, 2008

Mpeg Brazilian Waxing

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