CREATE OR REPLACE TRIGGER HLDB.TRI_TEST_USER_AFR
AFTER DELETE OR INSERT OR UPDATE
ON HLDB.BJ_TEST
REFERENCING NEW AS NEW OLD AS OLD
FOR EACH ROW
BEGIN
if inserting then
insert into bj_test(STU_ID,STU_NAME)values(:new.STU_ID,:new.STU_NAME);
end if;
if updating then
update bj_test set STU_NAME=:new:STU_NAME where STU_ID=:old.STU_ID;
end if;
END TRI_test_user_AFR;
Oracle触发器报Warning: compiled but with compilation errors
答案:2 悬赏:30 手机版
解决时间 2021-02-19 05:28
- 提问者网友:蓝琪梦莎
- 2021-02-18 19:12
最佳答案
- 五星知识达人网友:过活
- 2021-02-18 19:33
提了一手好问题,,,
全部回答
- 1楼网友:狂恋
- 2021-02-18 20:06
任务占坑
我要举报
如以上问答信息为低俗、色情、不良、暴力、侵权、涉及违法等信息,可以点下面链接进行举报!
大家都在看
推荐资讯