如何查看当前的用户模式？－－－－－－－－－－－－－

Question

用户hr登录以后,当前模式为hr
sql>show user
    hr
sql>alter session set CURRENT_SCHEMA= user1
     当前模式为user1请问：怎么知道当前的模式是user1 呢
  

Answer 1

select SYS_CONTEXT('USERENV','CURRENT_USER') CURRENT_USER ,
SYS_CONTEXT('USERENV','CURRENT_SCHEMA') CURRENT_SCHEMA from dual;

Answer 2

查的结果为空
SQL> select SYS_CONTEXT( 'USERENV ', 'CURRENT_USER ') CURRENT_USER , 
  2  SYS_CONTEXT( 'USERENV ', 'CURRENT_SCHEMA ') CURRENT_SCHEMA from dual; CURRENT_USER
--------------------------------------------------------------------------------
CURRENT_SCHEMA
--------------------------------------------------------------------------------
SQL> 

Answer 3

SQL> select sys_context('userenv','CURRENT_SCHEMA') from dual;SYS_CONTEXT('USERENV','CURRENT
--------------------------------------------------------------------------------
JZL_USERSQL> show user;
User is "jzl_user"SQL> select sys_context('userenv','CURRENT_SCHEMA') from dual;SYS_CONTEXT('USERENV','CURRENT
--------------------------------------------------------------------------------
JZL_USERSQL> alter session set current_schema=system;Session alteredSQL> select sys_context('userenv','CURRENT_SCHEMA') from dual;SYS_CONTEXT('USERENV','CURRENT
--------------------------------------------------------------------------------
SYSTEM