Re: Is the database server on the local machine?

From: <rs_arwar_at_hotmail.com>
Date: 2 Dec 2004 02:18:12 -0800
Message-ID: <1101982692.106489.36970@f14g2000cwb.googlegroups.com>

SYS_CONTEXT and V$SESSION as mentioned in the other posts will give you information about the client PC that is connected to the database. If you want the database server (where the database is running) IP/Hostname then you can call
select UTL_INADDR.Get_Host_Name from dual; or
select UTL_INADDR.Get_Host_Address from dual; I believe this is only available in 8i and above.

Regards
/Rauf Received on Thu Dec 02 2004 - 04:18:12 CST

This message: [ Message body ]
Next message: Jeffrey: "Now and then wrong data is inserted in oracle"
Previous message: billiauk_at_yahoo.co.uk: "Re: How do I use ROWNUM in a subquery (emulating SQL Server TOP n)"
In reply to: Lenny Palozzi: "Is the database server on the local machine?"
Next in thread: Mark C. Stock: "Re: Is the database server on the local machine?"
Reply: Mark C. Stock: "Re: Is the database server on the local machine?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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