Userenv () in Oracle ()

1. USEREVN () returns the information of the current user environment. opt can be: ENTRYID, SESSIONID, TERMINAL, ISDBA, LABLE, LANGUAGE, CLIENT_INFO, LANG, VSIZE1.ISDBA check whether the current user is DBA If yes returns trueSQLselectuserenv (isdba) fromdual; The USEREN------FALSE2.SESSION returns

1. USEREVN () returns information about the current user's environment. opt can be: ENTRYID, SESSIONID, TERMINAL, ISDBA, LABLE, LANGUAGE, CLIENT_INFO, LANG, VSIZE 1. ISDBA checks whether the current user is a DBA. If yes, true SQL select userenv ('isdba ') from dual; USEREN ------ FALSE 2 is returned. SESSION

1. USEREVN ()

Returns information about the current user environment. The opt can be:
ENTRYID, SESSIONID, TERMINAL, ISDBA, LABLE, LANGUAGE, CLIENT_INFO, LANG, VSIZE

1. ISDBA check whether the current user is a DBA. If yes, true is returned.
SQL> select userenv ('isdba ') from dual;

USEREN
------
FALSE

2. SESSION flag returned by the SESSION

SQL> select userenv ('sessionid') from dual;

USERENV ('sessionid ')
--------------------
152

4. ENTRYID returns the session population flag

SQL> select userenv ('entryid') from dual;

USERENV ('entryid ')
------------------
0

5. The flag of the current INSTANCE returned by the INSTANCE
SQL> select userenv ('instance') from dual;

USERENV ('instance ')
-------------------
1

6. The LANGUAGE returns the current environment variable.
SQL> select userenv ('language') from dual;

USERENV ('language ')
----------------------------------------------------
SIMPLIFIED CHINESE_CHINA.ZHS16GBK

7. LANG returns the abbreviation of the current environment language
SQL> select userenv ('lang ') from dual;

USERENV ('lang ')
----------------------------------------------------
ZHS

8. TERMINAL returns the identifier of the user's TERMINAL or machine
SQL> select userenv ('terminal') from dual;

USERENV ('termina
----------------
GAO

9. VSIZE (X) returns the size (bytes) of X.
SQL> select vsize (user), user from dual;

VSIZE (USER) USER
-----------------------------------------
6 SYSTEM

2. sys_context

Select
SYS_CONTEXT ('userenv', 'terminal') TERMINAL,
SYS_CONTEXT ('userenv', 'language') LANGUAGE,
SYS_CONTEXT ('userenv', 'sessionid') SESSIONID,
SYS_CONTEXT ('userenv', 'instance') INSTANCE,
SYS_CONTEXT ('userenv', 'entryid') ENTRYID,
SYS_CONTEXT ('userenv', 'isdba ') ISDBA,
SYS_CONTEXT ('userenv', 'nls _ TERRITORY ') nls_territory,
SYS_CONTEXT ('userenv', 'nls _ CURRENCY ') nls_currency,
SYS_CONTEXT ('userenv', 'nls _ CALENDAR ') nls_calendar,
SYS_CONTEXT ('userenv', 'nls _ DATE_FORMAT ') nls_date_format,
SYS_CONTEXT ('userenv', 'nls _ DATE_LANGUAGE ') nls_date_language,
SYS_CONTEXT ('userenv', 'nls _ SORT ') nls_sort,
SYS_CONTEXT ('userenv', 'current _ user') current_user,
SYS_CONTEXT ('userenv', 'current _ userid') current_userid,
SYS_CONTEXT ('userenv', 'session _ user') session_user,
SYS_CONTEXT ('userenv', 'session _ userid') session_userid,
SYS_CONTEXT ('userenv', 'proxy _ user') proxy_user,
SYS_CONTEXT ('userenv', 'proxy _ userid') proxy_userid,
SYS_CONTEXT ('userenv', 'db _ DOMAIN ') db_domain,
SYS_CONTEXT ('userenv', 'db _ name') db_name,
SYS_CONTEXT ('userenv', 'host') HOST,
SYS_CONTEXT ('userenv', 'OS _ user') OS _user,
SYS_CONTEXT ('userenv', 'external _ name') external_name,
SYS_CONTEXT ('userenv', 'IP _ address') ip_address,
SYS_CONTEXT ('userenv', 'network _ Protocol') network_protocol,
SYS_CONTEXT ('userenv', 'bg _ JOB_ID ') bg_job_id,
SYS_CONTEXT ('userenv', 'fg _ JOB_ID ') fg_job_id,
SYS_CONTEXT ('userenv', 'authentication _ type') authentication_type,
SYS_CONTEXT ('userenv', 'authentication _ data') authentication_data
From dual;