Summary of Column-Conversion Functions

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

These functions are used to perform 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.

These functions handle 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.

These functions work 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.

These functions are used to perform arithmetic calculations.

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

These functions work 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.

These are miscellaneous 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.