Re: SQL command to determine if DB is open

On 8 Aug 2001 07:17:11 -0700, amw157_at_aol.com (Andy Weiss) wrote:

Hi Andy,

As simple as it can get :
This Sql*PLUS script returns 1 when datase is open, 0 when not and *nothing* else.

*********'
set heading off;
SELECT case when status = 'OPEN' then 1 else 0 end as result FROM V$INSTANCE;

>> If I understand you correctly, how about using something like the v$instance
>> view (described next)
>
>I guess I should have been more specific. I need to do this from
>within a batch file. In other words, if the database is open, do
>these steps; if the database is not open, do these other steps.
>
>I don't think v$instance will do the trick for me. I need a statement
>that returns to me a boolean or an integer that tells whether the
>result of the statement was true or false.
>
>Andy

Regards,
Kenneth Koenraadt
Systems Consultant
Oracle DBA
plovmand@<no-spam>hotmail.com Received on Wed Aug 08 2001 - 14:42:17 CDT