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.
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;
Previous Topic: Re: Updating of Records
Next Topic: Re: Deleting rows from multiple tables
Goto Forum:
  


Current Time: Fri Mar 29 03:01:52 CDT 2024