How to get all database names in oracle using c#?

Question

I like to know any way to get all the database names in oracle using c#. I think we are not able to get all database names using query. I like to get all database names in oracle 9i server in C# code. Is their any way for that?

Answer 1

It should be enough to query databse server according to oracle specification :

How to Query Database Name in Oracle SQL Developer?

select * from v$database;

and execute this command in relative .NET adapter.

See a code example here: Oracle database connection data access from C#