USERENV

The Oracle and PL/SQL USERENV function return information about the current Oracle session.

The general format is:

USERENV(param)
param:
CLIENT_INFO Returns user session information (DBMS_APPLICATION_INFO)
ENTRYID Available auditing entry identifier
INSTANCE The identifier number of the current instance
ISDBA Returns TRUE if the user has DBA privileges. Otherwise FALSE
LANG The ISO abbreviation for the language
LANGUAGE The language, territory, and character of the session
SESSIONID The identifier of the auditing session
TERMINAL The OS identifier of the current session

Example 1:

select USERENV('LANGUAGE') from dual;

returns:

AMERICAN_AMERICA.WE8DEC