viernes, 15 de marzo de 2019

ALTER SESSION SCHEMA

By default, it is the user you used to log in, and you can query it as below:

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

You can change your current schema in your session however:
 
alter session set current_schema=HR;

No hay comentarios: