oracle系统函数sys_context
SQL> select sys_context('userenv','db_name') from dual;
SYS_CONTEXT('USERENV','DB_NAME
--------------------------------------------------------------------------------
orcl
SQL> select sys_context('userenv','language') from dual;
SYS_CONTEXT('USERENV','LANGUAG
--------------------------------------------------------------------------------
SIMPLIFIED CHINESE_CHINA.ZHS16GBK
SQL> select sys_context('userenv','terminal') from dual;
SYS_CONTEXT('USERENV','TERMINA
--------------------------------------------------------------------------------
SUN-PC
SQL> select sys_context('userenv','session_user') from dual;
SYS_CONTEXT('USERENV','SESSION
--------------------------------------------------------------------------------
SCOTT
SQL> select sys_context('userenv','current_schema') from dual;
SYS_CONTEXT('USERENV','CURRENT
--------------------------------------------------------------------------------
SCOTT
-------------------------------------------------
保持专注,只做一件事,做好这件事!@
-------------------------------------------------