How do I tell in which database I am?
January 8th, 2006 By Robert Vollman
select name from v$database;
or
select instance_name, host_name from v$instance;
or
SELECT SYS_CONTEXT(‘USERENV’,’DB_NAME’) FROM DUAL;
One Response to “How do I tell in which database I am?”
Leave a Reply
You must be logged in to post a comment.
January 16th, 2006 at 8:07 am
SELECT * FROM global_name;