Re: How do I get the Oracle 7 Server Name and SID using SQL statement?

not sure if this view is available in 7
but
select instance_name from v$instance;
will work on 8i

On 16 Jun 2003 06:25:36 -0700, afulajo_at_hotmail.com (Afulajo) wrote:

>Is there a way, using sql statement
>to get the Oracle Server Name and SID
>On Oracle 7?
>Thanks,

.......
We use Oracle 8.1.7.4 on Solaris 2.7 boxes remove NSPAM to email Received on Mon Jun 16 2003 - 10:59:37 CDT