Get Oracle Database name

Question

Hi,

How can I programmatically get the name of the Oracle database I am connecting to? I tried:

using (OracleConnection connection = new OracleConnection(oraConnectStr))
            {
                connection.Open();
                return connection.Database;
            }

but it returns empty string. I can't use the whole connection string because it may contain username/password.

Answer 1

Hi Grzenio,

you could query v$database:

SQL> SELECT NAME FROM v$database;

NAME
---------
PROD

Answer 2

Not every user has access to the V$ views. But everybody can run this:

SQL> select * from global_name
  2  /

GLOBAL_NAME
---------------------------------------------------
ORCL

SQL>

edit

If you want to solve this from inside c#, this article shows how to solve it through the ConnectionString.

Answer 3

You can use OracleConnectionStringBuilder object.

OracleConnectionStringBuilder connStrBuilder = new OracleConnectionStringBuilder(oraConnectStr);

connStrBuilder.DataSource will contain your information.

Check out: http://download.oracle.com/docs/html/E10927_01/OracleConnectionStringBuilderClass.htm#CHDHBCDA