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;
/
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;
/