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

Look at V$INSTANCE. I don't recall the columns in Oracle 7, and I no longer have such an old version running so I can't give you more info.

Also, you might want to consider upgrading to a version that is much more recent (8.1.7, 9.2.0).

HTH,
Brian

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

-- 
===================================================================

Brian Peasland
oracle_dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"