USERENV

Oracle

Example

SELECT USERENV('LANGUAGE') FROM DUAL;

Output

'AMERICAN_AMERICA.UTF8'

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.