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

From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 16 Jun 2003 15:39:07 -0700
Message-ID: <92eeeff0.0306161439.286f2c02@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,

You can also try,
select name from v$database;

Regards
/Rauf Sarwar Received on Mon Jun 16 2003 - 17:39:07 CDT

This message: [ Message body ]
Next message: Henrik Woldby: "ASP Connect to Oracle using OS authentication"
Previous message: Rauf Sarwar: "Re: loadjava: JAR with long package names"
In reply to: Afulajo: "How do I get the Oracle 7 Server Name and SID using SQL statement?"
Next in thread: Afulajo: "Re: How do I get the Oracle 7 Server Name and SID using SQL statement?"
Reply: Afulajo: "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