About
When a session starts, CURRENT_SCHEMA has the value of the schema owned by SESSION_USER.
Articles Related
How to
Get the current value
To get the current value of CURRENT_SCHEMA, CURRENT_USER, or SESSION_USER, use the userenv context:
SELECT sys_context('USERENV', 'CURRENT_SCHEMA') FROM dual;
Modify it
CURRENT_SCHEMA can be changed during the session with the SQL statement ALTER SESSION SET CURRENT_SCHEMA.
ALTER SESSION SET CURRENT_SCHEMA = MY_SCHEMA;
MY_SCHEMA without quote.
Oracle recommends against issuing ALTER SESSION SET CURRENT_SCHEMA from in a stored PL/SQL unit.