Home » RDBMS Server » Server Administration » Re: which database am i connected
Re: which database am i connected [message #370203] Wed, 04 November 1998 11:59 Go to next message
kumar biddala
Messages: 1
Registered: November 1998
Junior Member
select * from global_name;

the above query gives which DB you are connected to.

Report message to a moderator

Re: which database am i connected [message #370209 is a reply to message #370203] Tue, 10 November 1998 00:01 Go to previous message
Paul Miller
Messages: 5
Registered: November 1998
Junior Member
Careful about the use of global_name, not all installations use it - mine for instance - and furthermore, it is setable and does not get changed automatically as part of a database rename.

Use SELECT name FROM V$DATABASE;

Report message to a moderator

Previous Topic: Re: Updating of Records
Next Topic: Re: Deleting rows from multiple tables
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Mar 11 22:46:05 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.