7.34 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] [, ...] )

string

The name of a string (character) column or a literal string that is enclosed within single quote marks.

max_length

The maximum string length, in characters.

Example

The following concatenates two strings and results in ABC123.

PHONE_NO = @STRNCAT ('ABCDEF', 3, '123456', 3)