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博客 ” ，链接：https://blog.itpub.net/45259/viewspace-134863/ ，如需转载，请注明出处，否则将追究法律责任。
下一篇：
view about redo&undo
请登录后发表评论
登录
全部评论
