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

Home -> Community -> Usenet -> c.d.o.server -> Server hostname from SQL*Plus?

Server hostname from SQL*Plus?

From: Michael Wilson <mwilson_at_ti.com>
Date: 1997/05/28
Message-ID: <5mhh88$6fm@sf18.dseg.ti.com>#1/1

Is there any SQL select statement that would return the hostname of the server that Oracle is running on? We have created links to other instances on other systems and it would be nice to have such a statement. GLOBAL_NAME gives you the link name and V$VERSION provides Oracle version info, but no hostname.

Thanks,
  Michael


  Michael Wilson                     _/_/_/_/_/   _/_/_/
  SG Software Solutions                 _/         _/
  Defense Systems & Electronics        _/         _/
  Texas Instruments, Inc.             _/         _/
                                     _/       _/_/_/
  mwilson_at_ti.com ** 972-575-3448 ** 972-575-2628 (fax)
Received on Wed May 28 1997 - 00:00:00 CDT

Original text of this message

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