OraFAQ Forum: SQL & PL/SQL » how to know database name from sql prompt in oracle

Home » SQL & PL/SQL » SQL & PL/SQL » how to know database name from sql prompt in oracle

Tue, 22 April 2003 00:17

krishnaveni
Messages: 3
Registered: April 2003

Junior Member

how to the know database in which we are ?
if there any command to know in which database we are in present.

Tue, 22 April 2003 06:04

Art Metzer
Messages: 2480
Registered: December 2002

Senior Member

_{quote from krishnaveni:}
----------------------------------------------------------------------

how to the know database in which we are ?
if there any command to know in which database we are in present.

----------------------------------------------------------------------

SELECT name FROM v$database;

Wed, 23 April 2003 00:58

shawlin
Messages: 25
Registered: April 2003

Junior Member

Hello,

u can try this to get the database name.

select value from v$parameter where name = 'db_name'

Best Regards
shawlin

Previous Topic:	Cursors and fetch HELP PLEASE PLEASE!
Next Topic:	How to run SQL from an application?

Goto Forum:

]

Current Time: Fri Apr 26 00:23:11 CDT 2024