获取服务器主机名和IP地址:
SELECT UTL_INADDR.GET_HOST_NAME,UTL_INADDR.GET_HOST_ADDRESS FROM dual;
获取当前会话客户端主机名和IP地址:
SELECT SYS_CONTEXT('USERENV', 'HOST', 15),SYS_CONTEXT('USERENV', 'IP_ADDRESS', 15) FROM dual;
获取服务器主机名和IP地址:
SELECT UTL_INADDR.GET_HOST_NAME,UTL_INADDR.GET_HOST_ADDRESS FROM dual;
获取当前会话客户端主机名和IP地址:
SELECT SYS_CONTEXT('USERENV', 'HOST', 15),SYS_CONTEXT('USERENV', 'IP_ADDRESS', 15) FROM dual;