Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: How do I query the name of the server?
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