Oracle - Get IP address & host with

The utl_inaddr procedure:

SET serveroutput on

BEGIN

  DBMS_OUTPUT.PUT_LINE(UTL_INADDR.GET_HOST_NAME);  -- get local host name

  DBMS_OUTPUT.PUT_LINE(UTL_INADDR.GET_HOST_ADDRESS);  -- get local IP addr

END;

/

The sys_context procedure

select SYS_CONTEXT('USERENV', 'IP_ADDRESS', 15) ipaddr from dual;