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)
Examples
@STRLEN (ID_NO) @STRLEN ('abcd')