OracleSQL内置函数大全之三

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

USERENV('ENTRYID')

------------------

0

INSTANCE

返回当前INSTANCE的标志

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

USERENV('INSTANCE')

-------------------

1

LANGUAGE

返回当前环境变量

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

USERENV('LANGUAGE')

----------------------------------------------------

SIMPLIFIED CHINESE_CHINA.ZHS16GBK

LANG

返回当前环境的语言的缩写

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

USERENV('LANG')

----------------------------------------------------

ZHS

TERMINAL

返回用户的终端或机器的标志

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

USERENV('TERMINA

----------------

GAO

VSIZE(X)

返回X的大小(字节)数

SQL> select vsize(user),user from dual;

VSIZE(USER) USER

----------- ------------------------------

6 SYSTEM