@STRNCAT
Use the @STRNCAT
function to concatenate one or more strings to a maximum length.
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.
This function does not support NCHAR
or NVARCHAR
data types.
Syntax
@STRNCAT (string, max_length [, string, max_length] [, ...] )
Example
The following concatenates two strings and results in ABC123
.
PHONE_NO = @STRNCAT ('ABCDEF', 3, '123456', 3)
Parent topic: Column Conversion Functions