Skip to content
v1.36.6
Install

SQL Reference

USERENV

USERENV(parameter)

Section titled “USERENV(parameter)”
  • parameter: The session attribute to return, e.g. ‘LANGUAGE’, ‘SESSIONID’, ‘SID’, ‘TERMINAL’.

Example

Section titled “Example”
SELECT USERENV('LANGUAGE') FROM DUAL;

Output

Section titled “Output”
'AMERICAN_AMERICA.UTF8'

Explanation

Section titled “Explanation”

The ‘USERENV’ function provides information about the current session. In the example above, USERENV('LANGUAGE') returns the language and territory setting of the current session, along with the character set encoding value.