7.1 Summary of Column-Conversion Functions

This summary is organized according to the types of processing that can be performed with the Oracle GoldenGate functions.

Table 7-1 Performing Tests

Function	Description
`CASE`	Selects a value depending on a series of value tests.
`EVAL`	Selects a value based on a series of independent tests.
`IF`	Selects one of two values depending on whether a conditional statement returns `TRUE` or `FALSE`.

Table 7-2 Handling Missing Columns

Function	Description
`COLSTAT`	Returns an indicator that a column is `MISSING`, `NULL`, or `INVALID`.
`COLTEST`	Performs conditional calculations to test whether a column is `PRESENT`, `MISSING`, `NULL`, or `INVALID`.

Table 7-3 Working with Dates

Function	Description
`DATE`	Returns a date and time based on the format passed into the source column.
`DATEDIFF`	Returns the difference between two dates or datetimes.
`DATENOW`	Returns the current date and time.

Table 7-4 Performing Arithmetic Calculations

Function	Description
`COMPUTE`	Returns the result of an arithmetic expression.

Table 7-5 Working with Strings

Function	Description
`NUMBIN`	Converts a binary string into a number.
`NUMSTR`	Converts a string into a number.
`STRCAT`	Concatenates one or more strings.
`STRCMP`	Compares two strings.
`STREXT`	Extracts a portion of a string.
`STREQ`	Determines whether or not two strings are equal.
`STRFIND`	Finds the occurrence of a string within a string.
`STRLEN`	Returns the length of a string.
`STRLTRIM`	Trims leading spaces.
`STRNCAT`	Concatenates one or more strings to a maximum length.
`STRNCMP`	Compares two strings based on a specified number of characters.
`STRNUM`	Converts a number into a string.
`STRRTRIM`	Trims trailing spaces.
`STRSUB`	Substitutes one string for another.
`STRTRIM`	Trims leading and trailing spaces.
`STRUP`	Changes a string to uppercase.
`VALONEOF`	Compares a string or string column to a list of values.

Table 7-6 Other Functions

Function	Description
`AFTER`	Returns the after image of the specified column.
`BEFORE`	Returns the before image of the specified column.
`BEFOREAFTER`	Returns the before image of the specified column, if available, otherwise returns the after image.
`BINARY`	Maintains source binary data as binary data in the target column when the source column is defined as a character column.
`BINTOHEX`	Converts a binary string to a hexadecimal string.
`GETENV`	Returns environmental information.
`GETVAL`	Extracts parameters from a stored procedure as input to a `FILTER` or `COLMAP` clause.
`HEXTOBIN`	Converts a hexadecimal string to a binary string.
`HIGHVAL \| LOWVAL`	Constrains a value to a high or low value.
`@RANGE`	Divides rows into multiple groups of data for parallel processing.
`TOKEN`	Retrieves token data from a trail record header.
`OGG_SHA1`	Hashes some fields while replicating them to Operational Data Store.