Oracle
Oracle provides a few ways to determine which database you are working in. Admittedly, I usually know which database I’m working in, but recently I did an Oracle Database Express Edition (XE) install which did not goes has expected and I had reason to confirm which database I was actually in when the SQL*Plus session opened. So, this lead me to consider how one would prove exactly which database they were connected to. As it happens, Oracle has a few ways to quickly display which database you are connected to and here are two easy ways to find out your Oracle database name in SQL*Plus:
- V$DATABASE
- GLOBAL_NAME
Checking the GLOBAL_NAME table
The First method is to run a quick-select against the GLOBAL_NAME table, which. is publicly available to logged-in users of the database
Example GLOBAL_NAME Select Statement
select * from global_name;
Example GLOBAL_NAME Select Statement
Checking the V$DATABASE Variable
The second method is to run a quick-select a V$database. However, not everyone will have access to the V$database variable.
Example V$database Select Statement
select name from V$database;
Example V$database Select Statement
