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

From: michael ngong <mngong_at_yahoo.com>
Date: 16 Jun 2003 10:45:27 -0700
Message-ID: <ecf365d5.0306160945.2235fc7a@posting.google.com>

afulajo_at_hotmail.com (Afulajo) wrote in message news:<c721cf41.0306160525.e7bc799_at_posting.google.com>...
> Is there a way, using sql statement
> to get the Oracle Server Name and SID
> On Oracle 7?
> Thanks,

v$instance should give you what you want. I have no version 7 to double check
HTH
Michael Tubuo Ngong Received on Mon Jun 16 2003 - 12:45:27 CDT

This message: [ Message body ]
Next message: Jane O: "Re: Oracle 9i install ate my Microsoft IIS 5"
Previous message: Hans Forbrich: "Re: Weird Snapshot Refresh Error"
In reply to: Afulajo: "How do I get the Oracle 7 Server Name and SID using SQL statement?"
Next in thread: Rauf Sarwar: "Re: How do I get the Oracle 7 Server Name and SID using SQL statement?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US