oracle 插入触发器报 ORA-04071: 缺失 BEFORE, AFTER 或 INSTEAD OF 关键字

2024-12-26 22:09:09
推荐回答(2个)
回答1:

create or replace trigger trizspService
before insert on XZSP_SERVICE
begin
insert into TB_YY_ITEM(ITEM_ID,ITEM_NAME,GROUP_ID)
select ITEM_ID,ITEM_NAME,GROUP_ID from inserted;
end;
如果是insert之前触发就是before, 否则就是after

回答2:

create trigger trixzspService before on XZSP_SERVICE