CREATE OR REPLACE TRIGGER xxxxxxxxxx AFTER update ON xxx.xxxxxxxxx REFERENCING NEW AS NEW OLD AS OLD FOR EACH ROW DECLARE .... .... BEGIN v_NEW:= :new.xxxxxxx; v_OLD:= :old.xxxxxxx;
END;
当前”更新的行数据 是什么意思?要select出来被更新的行? 那你不是用select * from table <你update后面的where条件>可以查询到要获取有多少行被更新了,使用SQL%ROWCOUNT!
AFTER update
ON xxx.xxxxxxxxx
REFERENCING NEW AS NEW OLD AS OLD
FOR EACH ROW
DECLARE
....
....
BEGIN
v_NEW:= :new.xxxxxxx;
v_OLD:= :old.xxxxxxx;
END;
那你不是用select * from table <你update后面的where条件>可以查询到要获取有多少行被更新了,使用SQL%ROWCOUNT!