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