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:

Leave a Reply

Powered by WordPress | Designed by Elegant Themes

Pin It on Pinterest

Share This