17,377
社区成员
发帖
与我相关
我的任务
分享
CREATE OR REPLACE TRIGGER FWDJ_COUNTTIGGER
AFTER INSERT OR UPDATE OF A, B, C, D ON FWDJ
FOR EACH ROW
DECLARE
PRAGMA AUTONOMOUS_TRANSACTION;
BEGIN
UPDATE FWDJ SET E = A || B || C || D WHERE A = :NEW.ARCHIVEID;
COMMIT;
END;
/
[Quote=引用楼主 deallylau 的帖子:]