Home » Developer & Programmer » Forms » how to retrive database names
how to retrive database names [message #118413] Thu, 05 May 2005 01:12 Go to next message
Sabeen
Messages: 25
Registered: March 2005
Location: Pakistan
Junior Member
hi, can anyone tell me how to retrive database names created in oracle 9i.thanx

Report message to a moderator

Re: how to retrive database names [message #118418 is a reply to message #118413] Thu, 05 May 2005 01:52 Go to previous message
saadatahmad
Messages: 452
Registered: March 2005
Location: Germany/Paderborn
Senior Member
We have views such as v$database, v$instance to view the database information.
connect to the database as system/manager

DESC v$database
DESC v$instance

SELECT name
FROM v$database;

Regards.

Report message to a moderator

Previous Topic: :system_record_status
Next Topic: DDE.Execute
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Sep 19 18:06:50 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.