oracle 中如何获取本机ip地址,根据IP地址获取域名?
来源:互联网 发布:ubuntu服务器密码修改 编辑:程序博客网 时间:2024/05/15 07:10
-----解析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
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 0
- oracle 中如何获取本机ip地址,根据IP地址获取域名?
- 根据域名获取IP地址
- 根据域名获取IP地址
- 根据域名获取ip地址
- 一、java根据域名获取ip地址
- 根据域名获取IP地址 gethostbyname()函数
- iOS 根据域名获取ip地址
- C/C++ 根据域名获取IP地址
- 如何获取本机IP地址
- Flex如何获取本机IP地址
- 如何获取本机的IP地址
- C#------如何获取本机IP地址
- 如何获取本机IP地址
- ios中 根据域名动态获取ip地址
- shell中获取本机ip地址
- shell中获取本机ip地址
- Qt 中获取本机IP地址
- 如何在Node.js中获取本机IP地址
- redis内存优化
- Ubuntu 彻底删除 Mysql 然后重装 Mysql
- uboot 环境变量设置研究
- 制作一个带SNTP的智能手表
- 淘宝卖家评价体系
- oracle 中如何获取本机ip地址,根据IP地址获取域名?
- html中设置锚点定位的几种常见方法
- 九度oj 1087
- 线段树入门
- 小白学开发(iOS)OC_ id类型(2015-07-28)
- HDU 5319(2015多校3)-Painter(dfs)
- 欢迎使用CSDN-markdown编辑器
- LeetCode || Spiral Matrix II
- VB.NET的拖放操作