Returns the user name.
Returns
LONG VARCHAR
Note: The
result data type is a LONG
VARCHAR. If you use SUSER_NAME in a SELECT INTO statement,
you must have an Unstructured Data Analytics Option license or use CAST and
set SUSER_NAME to the correct data type and size.
Examples
The following statement returns the value DBA:
SELECT SUSER_NAME ( 1 ) FROM iq_dummy
The following statement returns the value SYS:
SELECT SUSER_NAME ( 0 ) FROM iq_dummy