2 Column Conversion Functions

The column conversion functions of Oracle GoldenGate enable you to manipulate source values into the appropriate format for target columns.You can manipulate numbers and characters, perform tests, extract parameter values, return environment information, and more. For more information about using these functions, see Administering Oracle GoldenGate.

Topics:

• Summary of Column-Conversion Functions
  This summary is organized according to the types of processing that can be performed with the Oracle GoldenGate functions.
• @RANGE
  
• @AFTER
  
• @BEFORE
  
• @BEFOREAFTER
  
• @BINARY
  
• @BINTOBASE64
  
• @BINTOHEX
  
• @CASE
  
• @COLSTAT
  
• @COLTEST
  
• @COMPUTE
  
• @DATE
  
• @DATEDIFF
  
• @DATENOW
  
• @DDL
  
• @EVAL
  
• @GETENV
  
• @GETVAL
  
• @HEXTOBIN
  
• @HIGHVAL | LOWVAL
  
• @IF
  
• @NUMBIN
  
• @NUMSTR
  
• @OGG_SHA1
  
• @STRCAT
  
• @STRCMP
  
• @STRCMPNULL
  
• @STREQ
  
• @STREQNULL
  
• @STREXT
  
• @STRFIND
  
• @STRLEN
  
• @STRLTRIM
  
• @STRNCAT
  
• @STRNCMP
  
• @STRNUM
  
• @STRRTRIM
  
• @STRSUB
  
• @STRTRIM
  
• @STRUP
  
• @TOKEN
  
• @VALONEOF
  

2.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.

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.