RE: get ip addr from sqlplus

Extract machine name from v$session, and then a host call to 'nslookup' ? External Procedure?

• Kirti

-----Original Message-----
Sent: Thursday, May 22, 2003 2:42 PM
To: Multiple recipients of list ORACLE-L

What about other sessions (not your own)?

Igor Neyman, OCP DBA
ineyman_at_perceptron.com

-----Original Message-----
Delgado
Sent: Thursday, May 22, 2003 1:23 PM
To: Multiple recipients of list ORACLE-L

Use:

select sys_context('userenv', 'ip_address') ip_address,
sys_context('userenv', 'current_user') current_user from dual
/

(8i or above)...

HTH
JL

-

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Deshpande, Kirti
  INET: kirti.deshpande_at_verizon.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).