@STRLEN

Use the @STRLEN function to return the length of a string, expressed as the number of characters.

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

@STRLEN (string)

string

The name of a string (character) column or a literal string. Enclose literals within single quote marks.

Examples

@STRLEN (ID_NO)

@STRLEN ('abcd')