oracle 中怎么获取本机ip地址，根据IP地址获取域名

oracle 中如何获取本机ip地址，根据IP地址获取域名？
-----解析ip 地址
SQL> select utl_inaddr.get_host_address('google.com') from dual;

UTL_INADDR.GET_HOST_ADDRESS('GOOGLE.COM')
--------------------------------------------------------------------------------
122.229.30.202


-----获取本机IP地址
SQL> select utl_inaddr.get_host_address from dual;
GET_HOST_ADDRESS
--------------------------------------------------------------------------------
10.80.18.241



-----根据IP地址反向解析主机名
SQL> select utl_inaddr.get_host_name('10.80.18.241') from dual;
UTL_INADDR.GET_HOST_NAME('10.80.18.241')
--------------------------------------------------------------------------------
lixora




SQL> select utl_inaddr.get_host_name('10.80.18.243') from dual;


UTL_INADDR.GET_HOST_NAME('10.80.18.243')
--------------------------------------------------------------------------------
oracle11g-dagi




SQL> select utl_inaddr.get_host_name('8.8.8.8') from dual;
UTL_INADDR.GET_HOST_NAME('8.8.8.8')
--------------------------------------------------------------------------------
google-public-dns-a.google.com



SQL> select utl_inaddr.get_host_name('10.80.18.210') from dual;
select utl_inaddr.get_host_name('10.80.18.210') from dual
       *
ERROR at line 1:
ORA-29257: host 10.80.18.210 unknown
ORA-06512: at "SYS.UTL_INADDR", line 4
ORA-06512: at "SYS.UTL_INADDR", line 35
ORA-06512: at line 1



SQL> select utl_inaddr.get_host_name('10.80.19.210') from dual;
select utl_inaddr.get_host_name('10.80.19.210') from dual
       *
ERROR at line 1:
ORA-29257: host 10.80.19.210 unknown
ORA-06512: at "SYS.UTL_INADDR", line 4
ORA-06512: at "SYS.UTL_INADDR", line 35
ORA-06512: at line 1

1楼u010850027昨天 16:39

感谢小伙伴的分享，学习了`(*∩_∩*)′

Re: royjj昨天 18:34

回复u010850027n有机会多多交流