Home » RDBMS Server » Server Administration » Database name
Database name [message #374510] Fri, 15 June 2001 10:50 Go to next message
CHACKO
Messages: 11
Registered: March 2001
Junior Member
How can we find out the database name?
I have test database,production database, and so on..
is there any command in sql to figure out which database I am using?

Thanks

Report message to a moderator

Re: Database name [message #374511 is a reply to message #374510] Fri, 15 June 2001 11:15 Go to previous messageGo to next message
Bala
Messages: 205
Registered: November 1999
Senior Member
Hi,

select name, value from v$parameter where
name = 'db_name';

or

select name from v$database;

Report message to a moderator

Re: Database name [message #374518 is a reply to message #374510] Fri, 15 June 2001 18:18 Go to previous message
Andrew again...
Messages: 270
Registered: July 2000
Senior Member
http://www.ibi.co.za/frank/scripts/sql/whoami.txt

Report message to a moderator

Previous Topic: Describing all the tables in a database
Next Topic: delete a column from a table
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Jul 06 18:08:31 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.