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 -> Re: Can define HOSTNAME in package spec?

Re: Can define HOSTNAME in package spec?

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 18 Jul 2005 06:22:47 -0700
Message-ID: <1121692967.211215.324090@g43g2000cwa.googlegroups.com> 





The value of v$session.terminal and the hostname for the Oracle
database server are not the same thing nor is the terminal necessarily
the host name of the client server.



If you want the client server look at v$session.machine



If you want the database server host then try



select


  utl_inaddr.get_host_name as hn


from


  sys.dual



HTH -- Mark D Powell --
Received on Mon Jul 18 2005 - 08:22:47 CDT












Original text of this message













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