Changing current schema

 

Yet another query to change the current schema. Useful when your script is expected to run under certain user but is actually executed by other user. It is always safe to set the current user to what your script expects.

 

ALTER SESSION SET CURRENT_SCHEMA = new_schema;