Create or replace trigger biu_tabletest Before insert or update On tabletest for each row begin if updating then update tabletest set ModifyTime = sysdate; elseif inserting then insert into tabletest values(:field1, ...sysdate); end if; end biu_tabletest;
DROP TRIGGER UpdataModifyTime; CREATE OR REPLACE TRIGGER UpdataModifyTime AFTER INSERT OR UPDATA ON Employee FOR EACH ROW BEGIN update Employee set ModifyTime = to_char(sysdate,'yyyy-mm-dd hh24:mi'); END; 如果我这样写不会把Employee表中每个记录的ModifyTime都改了吧。
DROP TRIGGER UpdataModifyTime; CREATE OR REPLACE TRIGGER UpdataModifyTime AFTER INSERT OR UPDATA ON Employee FOR EACH ROW BEGIN update Employee set ModifyTime = to_char(sysdate,'yyyy-mm-dd hh24:mi'); END; 如果我这样写不会把Employee表中每个记录的ModifyTime都改了吧。
DROP TRIGGER UpdataModifyTime; CREATE OR REPLACE TRIGGER UpdataModifyTime AFTER INSERT OR UPDATA ON Employee FOR EACH ROW BEGIN update Employee set ModifyTime = to_char(sysdate,'yyyy-mm-dd hh24:mi'); END; 这样写不会把Employee表中的每个记录中的ModifyTime都改了吧。 主要是我对FOR EACH ROW的用法不太清楚
/--创建一个单表的insert和update触发器:
Create or replace trigger biu_tabletest
Before insert or update On tabletest
for each row
begin
if updating then
update tabletest set ModifyTime = sysdate;
elseif inserting then
insert into tabletest values(:field1, ...sysdate);
end if;
end biu_tabletest;
CREATE OR REPLACE TRIGGER UpdataModifyTime
AFTER INSERT OR UPDATA ON Employee
FOR EACH ROW
BEGIN
update Employee set ModifyTime = to_char(sysdate,'yyyy-mm-dd hh24:mi');
END;
如果我这样写不会把Employee表中每个记录的ModifyTime都改了吧。
CREATE OR REPLACE TRIGGER UpdataModifyTime
AFTER INSERT OR UPDATA ON Employee
FOR EACH ROW
BEGIN
update Employee set ModifyTime = to_char(sysdate,'yyyy-mm-dd hh24:mi');
END;
如果我这样写不会把Employee表中每个记录的ModifyTime都改了吧。
CREATE OR REPLACE TRIGGER UpdataModifyTime
AFTER INSERT OR UPDATA ON Employee
FOR EACH ROW
BEGIN
update Employee set ModifyTime = to_char(sysdate,'yyyy-mm-dd hh24:mi');
END;
这样写不会把Employee表中的每个记录中的ModifyTime都改了吧。
主要是我对FOR EACH ROW的用法不太清楚