viernes, 15 de febrero de 2008

Obtener Datos de Conexión

select substr(userenv('TERMINAL'),1,40) from dual

select substr(userenv('SESSIONID'), 1, 10) from dual

select userenv('ISDBA') from dual

select substr(sys_context('USERENV','OS_USER'),1,50) from dual

select substr(sys_context('USERENV','NETWORK_PROTOCOL'),1,50) from dual

select substr(sys_context('USERENV','IP_ADDRESS'),1,50) from dual

select substr(sys_context('USERENV','HOST'),1,50) from dual

select substr(sys_context('USERENV','IDENTIFICATION_TYPE'),1,50) from dual

select substr(sys_context('USERENV','DB_NAME'),1,50) from dual

select substr(sys_context('USERENV','CURRENT_SCHEMA'),1,50) from dual

select substr(sys_context('USERENV','GLOBAL_CONTEXT_MEMORY'),1,50) from dual