Manipulating Numbers and Character Strings

To convert numbers and character strings, Oracle GoldenGate supplies the following functions:

Table 7-8 Conversion Functions for Numbers and Characters

Purpose Conversion Function

Convert a binary or character string to a number.

@NUMBIN

@NUMSTR

Convert a number to a string.

@STRNUM

Compare strings.

@STRCMP

@STRNCMP

Concatenate strings.

@STRCAT

@STRNCAT

Extract from a string.

@STREXT

@STRFIND

Return the length of a string.

@STRLEN

Substitute one string for another.

@STRSUB

Convert a string to upper case.

@STRUP

Trim leading or trailing spaces, or both.

@STRLTRIM

@STRRTRIM

@STRTRIM