Search This Blog

Total Pageviews

Wednesday, 12 October 2011

Oracle current schema current_schema

set current schema

alter session set current_schema=SCHEMA_NAME -- ****** without quotes*

alter session set current_schema=anuj;


alter session set current_schema= &schema ;


get your current_schema info

SELECT SYS_CONTEXT('USERENV','CURRENT_SCHEMA') from DUAL;

No comments:

Oracle DBA

anuj blog Archive