Import SQL's
SELECT sys_context('userenv','instance_name') FROM dual;
select value from v$parameter where name like '%service_name%';
SELECT sys_context('USERENV', 'SID') FROM DUAL;
select sys_context('userenv','db_name') from dual;
select sys_context('userenv', 'server_host') from dual;
select ora_database_name from dual;
select * from global_name;
How to get SID and Service Name?
How to get SID and Service Name?
Malik Sikandar Hayat
admin@erpstuff.com
admin@erpstuff.com
Who is online
Users browsing this forum: No registered users and 2 guests