USER_NAME function [System]

Function

Returns the user name.

Syntax

USER_NAME ( [user-id ] )

Parameters

user-id The user identification number.

Examples

The following statement returns the value “DBA”:

SELECT USER_NAME ( 1 ) FROM iq_dummy

The following statement returns the value “SYS”:

SELECT USER_NAME ( 0 ) FROM iq_dummy

Standards and compatibility

See also

“SUSER_NAME function [System]”

“USER_ID function [System]”