select database_status from V$instance;
-----
Original Message -----
From: sandeep monu mehta
To: LazyDBA.com Discussion
Sent: Thursday, October 16, 2003 2:52 PM
Subject: Current Database


hi all,
can anybody tell me how i can see my active database in sql plu, is there any data dictionary view i can query to get this ?,
i connected with the following syntax
c:\>sqlplus
enter user name : sys as sysdba
password : change_on_install


thanks in advance
Sandeep








Oracle LazyDBA home page