1. Oracle GoldenGate Classic Architecture Documentation
  2. Administer
  3. Data Management
  4. Mapping and Manipulating Data
  5. Testing and Transforming Data
  6. Manipulating Numbers and Character Strings

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.

@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