Oracle如何提取域名,oracle中如何擷取本機ip位址，根據IP位址擷取域名？

-----解析ip 位址 SQL select utl_inaddr.get_host_address( #39;google.com #39;) from dual; UTL_INADDR.GET_HOST_ADDRESS( #39;GOOGLE.COM #39;) -----------

oracle中如何擷取本機ip位址，根據IP位址擷取域名？

2015-07-31 11:50:54--點選數:

-----解析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

相關文章

無相關資訊

，