select sys_context('userenv','ip_address') from dual; 可以用触发器实现 create or replace trigger tr_test after delete on table1 for each row declare v_ip table2.c_ip%type; begin select sys_context ('userenv','ip_address') into v_ip from dual; insert into table2 values(v_ip); end;
直接用Request.getRemoteAddr()就可以得到远程客户的IP地址~~
可以用触发器实现
create or replace trigger tr_test
after delete on table1
for each row
declare
v_ip table2.c_ip%type;
begin
select sys_context ('userenv','ip_address') into v_ip from dual;
insert into table2 values(v_ip);
end;