UTL_INADDR 用於在 PL/SQL 中解析主機名與 IP 地址,適用於局域網與 Internet 環境。
-- 查詢外網域名 IP
SELECT UTL_INADDR.GET_HOST_ADDRESS('www.qq.com') FROM dual;
-- 查詢本機 IP
SELECT UTL_INADDR.GET_HOST_ADDRESS() FROM dual;
-- 查詢局域網主機名 IP
SELECT UTL_INADDR.GET_HOST_ADDRESS('yuechu') FROM dual;
失敗拋出異常,需 EXCEPTION WHEN OTHERS THEN ... 捕獲。
-- 本機主機名
SELECT UTL_INADDR.GET_HOST_NAME() FROM dual;
-- 局域網 IP 反解
SELECT UTL_INADDR.GET_HOST_NAME('192.168.0.156') FROM dual;
-- 公網 IP 反解
SELECT UTL_INADDR.GET_HOST_NAME('219.153.50.84') FROM dual;
EXECUTE ON UTL_INADDR 權限(通常授予 PUBLIC)BEGIN DBMS_NETWORK_ACL_ADMIN.APPEND_HOST_ACE(host => '*', lower_port => 1, upper_port => 65535, ace => XS$ACE_TYPE(privilege_list => XS$NAME_LIST('resolve'), principal_name => 'SCOTT', principal_type => XS_ACL.PTYPE_DB)); END;