Re: Vreifying the connection to the database?

From: Mike Morgan <mike.morgan_at_teldta.com>
Date: 1995/07/28
Message-ID: <3vb0jk$l6c_at_madison.tdsnet.com>#1/1


Amit,

If you have access to the V$ tables, you can

SELECT VALUE FROM V$PARAMETER WHERE NAME='db_name';

or if you have V7

SELECT NAME FROM V$DATABASE; Hope this helps,
Mike

-- 

*******************************************************
Mike Morgan Technology Integration Services - Unix DBA email: Mike.Morgan_at_teldta.com TDS Computing Services 301 S. Westfield Road Madison, WI 53705 USA (608)845-4661
*******************************************************
Received on Fri Jul 28 1995 - 00:00:00 CEST

Original text of this message