Helpful Oracle hints I've found and saved

Find out which Oracle Instance you're connected to

Here's a quick little sql query that shows what Oracle instance (what database) you're connected to:

SELECT sys_context('USERENV','DB_NAME') AS Instance
FROM dual;

And that's all thanks to:

http://www.techonthenet.com/oracle/questions/instance.php

Leave a Reply

Powered by WordPress | Designed by Elegant Themes

Pin It on Pinterest

Shares
Share This