end;

--退出

create or replace trigger trigger_test before logoff on database

begin

insert into log_table(userName,logoff_time,address) values(ora_login_user,sysdate,ora_client_ip_address);

end;