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

posted @ 2012-05-15 15:28  逆水寒龙  阅读(365)  评论(0编辑  收藏  举报