Home › Oracle: set and display current schema

Oracle: set and display current schema 

Dr. Xi
Joined:
04/09/2007
Posts:
710

February 05, 2010 23:53:17    Last update: February 05, 2010 23:53:17 
SQL> select sys_context('userenv', 'current_schema') from dual;

SYS_CONTEXT('USERENV','CURRENT_SCHEMA')
-------------------------------------------------------------------------------

JPA

SQL> alter session set current_schema = sys;

Session altered.

SQL> select sys_context('userenv', 'current_schema') from dual;

SYS_CONTEXT('USERENV','CURRENT_SCHEMA')
-------------------------------------------------------------------------------

SYS

SQL>

Share |
| Comment  | Tags
 
Easy email testing with http://www.ximailstop.com