Re: Get hostname of Oracle Server from within SQLPlus

From: Uday <un2000_at_hotmail.com>
Date: 30 Jul 2001 10:31:08 -0700
Message-ID: <fcf0102e.0107300931.28692ff6@posting.google.com>

Try doing "select host_name from v$instance;"

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
Received on Mon Jul 30 2001 - 12:31:08 CDT