Re: Get hostname of Oracle Server from within SQLPlus

lmcstmc_at_lmc.ericsson.se (steve) wrote in message news:<bdd5c887.0107300621.7fae68d5_at_posting.google.com>...
> Hi,
>
> Is there a SQL command I can issue from within SQLPlus
> that will return the hostname of the Oracle Server I
> am currently connected to (assuming it is a remote server).
>
> Something along the lines of 'select name from v$database;'
>
> Thanks.
>
> Steve

Try:

Select host_name from v$instance;

Mike Received on Mon Jul 30 2001 - 15:05:06 CDT