Friday, May 05, 2017

Current Schema Name

To find out the current schema that we are connect to, we may use function sys_context(). I connected to Oracle SQL Live at and ran the following query:

select sys_context('USERENV', 'SESSION_USER') from dual;

The returned result showed that the schema name was APEX_PUBLIC_USER.