7.25 STRCAT

Use the @STRCAT function to concatenate one or more strings or string (character) columns. Enclose literal strings within single quote marks.

For this function, Oracle GoldenGate supports the use of an escape sequence to represent characters in a string column in Unicode or in the native character encoding of the Microsoft Windows, UNIX, and Linux operating systems. The target column must be a SQL Unicode data type if any argument is supplied as Unicode.

Syntax

@STRCAT (string1, string2 [, ...])

string1

The first column or literal string to be concatenated.

string2

The next column or literal string to be concatenated.

Example

The following creates a phone number from three columns and includes the literal formatting values.

PHONE_NO = @STRCAT (AREA_CODE, PREFIX, '-', PHONE)