Use the @STRUP
function to change an alphanumeric string or string (character) column to upper case.
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
@STRUP (string)
Example
The following returns SALESPERSON
.
@STRUP ('salesperson')