Manipulating Numbers and Character Strings
To convert numbers and character strings, Oracle GoldenGate supplies the following functions:
Table 8-8 Conversion Functions for Numbers and Characters
Purpose | Conversion Function |
---|---|
Convert a binary or character string to a number. |
|
Convert a number to a string. |
|
Compare strings. |
|
Concatenate strings. |
|
Extract from a string. |
|
Return the length of a string. |
|
Substitute one string for another. |
|
Convert a string to upper case. |
|
Trim leading or trailing spaces, or both. |
|