Home » SQL & PL/SQL » SQL & PL/SQL » SQL PLUS COMMAND
SQL PLUS COMMAND [message #8096] Sat, 26 July 2003 08:31 Go to next message
A. Anandhi
Messages: 2
Registered: July 2003
Junior Member
What is the SQL PLUS COMMAND to find which database we are connected to?

Report message to a moderator

Re: SQL PLUS COMMAND [message #8098 is a reply to message #8096] Sat, 26 July 2003 10:14 Go to previous message
WALID
Messages: 31
Registered: August 2002
Member
to get database name use one of these methods:

1)SELECT name from v$database
2)SQL> show parameter db_name
3) select value from v$parameter where name='db_name'

this was in an earlier post.

Report message to a moderator

Previous Topic: connect to oracle 9 i database using sqlplus2.3 or the one available with oracle 7.3 client
Next Topic: SUBQUERY HELP
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 25 18:02:43 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.