Home » SQL & PL/SQL » SQL & PL/SQL » Checking the current database name- urgent pls
Checking the current database name- urgent pls [message #2370] Wed, 10 July 2002 00:00 Go to next message
Prabha R
Messages: 21
Registered: October 2001
Junior Member
Hi,
I have oracle 8i installed in Sun Solaris. when i try to connect to the database using system/manager id, it is getting connected. But I do not know which database it has connected to. We have 2 databases dba and oradal. Could any of you tell me the command for finding out the current database i'm working on. Any immediate help is greatly appreciated.

Thanks and Regards,
prabha

Report message to a moderator

Re: Checking the current database name- urgent pls [message #2371 is a reply to message #2370] Wed, 10 July 2002 01:03 Go to previous message
Arvind L
Messages: 27
Registered: June 2001
Junior Member
Hi,

Execute this query from sys or system id
select name from v$database;

Regards
Arvind

Report message to a moderator

Previous Topic: how to get the tilldate value
Next Topic: MULTIPLE INSERTS
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 19 03:09:04 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.