触发器使用

create or replace trigger trigger_tablename
 before insert or update on tablename
  for each row
declare
begin
  if inserting then
     select sysdate into :new.INSERT from dual;
  elsif updating then
    select sysdate into :new.update from dual;
  end if;
end trigger_tablename;
/




create or replace trigger trigger_tablename
before insert or update on nsdpf.tb_wz_ip
for each row
declare
begin
  if inserting then
     select sysdate into :new.INSERT from dual;
  elsif updating then
    select sysdate into :new.update from dual;
  end if;
end trigger_tablename;
/