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;