how to get the current schema name
https://community.oracle.com/tech/developers/discussion/495481/how-to-get-the-current-schema-name
- get the logged in user:
select user from dual;
select sys_context('USERENV','SESSION_USER') from dual;
- get schema currently used to resolve object references:
select sys_context('USERENV','CURRENT_SCHEMA') from dual;
accessing a table without specifying the schema name
https://stackoverflow.com/questions/21846648/accessing-a-table-without-specifying-the-schema-name
- alter session set current_schema = new_default_schema_name;