database name

Greenhorn

Posts: 5

posted 19 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

how can i look for database name from the sql prompt???.
what r the other options i can look for the database name ...
thanks.

Mark Spritzler

ranger

Posts: 17347

I like...

posted 19 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Um, why do you need to know the database name?
The reason why I ask is this. If you are a DBA then you already know the database name. If you are a developer, then you don't need to know the database name. In oracle, check out your tnsnames.ora file in the ORACLE_HOME\netork\admin directory. Find the entry that you use to connect to the database and you will find the service name, which is all you really would need.
Hope that helps.
Mark

Perfect World Programming, LLC - iOS Apps
How to Ask Questions the Smart Way FAQ

Beksy Kurian

Ranch Hand

Posts: 254

posted 19 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

...and if you really want to know the db_name, use this query
select name from v$database;

Beksy

Arch enemy? I mean, I don't like you, but I don't think you qualify as "arch enemy". Here, try this tiny ad:

a bit of art, as a gift, the permaculture playing cards

https://gardener-gift.com