[A]服务器(817以上):utl_inaddr.get_host_address
客户端:sys_context('userenv','ip_address')
服务器:
SQL> select utl_inaddr.get_host_address from dual;
GET_HOST_ADDRESS
--------------------------------------------------------------------------------
127.0.0.1
客户端:
SQL> select sys_context('userenv','ip_address') from dual;
SYS_CONTEXT('USERENV','IP_ADDRESS')
-----------------------------------------------------------------
192.168.6.6
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/51862/viewspace-180515/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/51862/viewspace-180515/