ORACLE: how to get the current schema name | accessing a table without specifying the schema name

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;