How to get server IP address...
UTL_INADDR useful package in oracle 9i&10g;
declare
v_ip_address varchar2(50);
v_host_name v$instance.host_name%type;
/*UTL_INADDR useful package added in oracle 9i
and 10g ( not in oracle 8i and before) */
begin
select v.HOST_NAME
into v_host_name
from v$instance v;
SELECT UTL_INADDR.GET_HOST_ADDRESS(v_host_name)
into v_ip_address
FROM DUAL;
dbms_output.put_line(v_host_name||':'||v_ip_address);
end;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/45259/viewspace-134863/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/45259/viewspace-134863/