Tuesday, May 16, 2017

reconstructing oracle connect string from userenv details

select sys_context('userenv','IP_ADDRESS') || '=' || sys_context('userenv','instance_name')  || '.' || sys_context('userenv','db_domain') from dual;

No comments:

Post a Comment