Client IP 접속자IP 확인

CREATE OR REPLACE TRIGGER ip_look AFTER LOGON ON DATABASE
DECLARE ipinfo VARCHAR2(30);
BEGIN
SELECT SYS_CONTEXT('USERENV','IP_ADDRESS') INTO ipinfo FROM DUAL;
DBMS_APPLICATION_INFO.SET_CLIENT_INFO(ipinfo);
END;
/