Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: How do I query the name of the server?

Re: How do I query the name of the server?

From: Karsten Farrell <kfarrell_at_belgariad.com>
Date: Tue, 19 Aug 2003 17:46:20 GMT
Message-ID: <MPG.19ac02439e4529bc989849@news.la.sbcglobal.net>


Hi Fredrik Wahlgren, you said...
> Hi
>
> I hava a client application for which I need to know the name of the server
> where the Oracle dbms resides. How do I do that ? In SQL Server you can do
> this select @@server but how is this done with Oracle?
>
> Regards,
> Fredrik
>

You can get it this way (and maybe other ways as well):

select host_name from v$instance;

-- 
[:%s/Karsten Farrell/Oracle DBA/g]
Received on Tue Aug 19 2003 - 12:46:20 CDT

Original text of this message

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