给你一个成功的例子参考,除了'/',还有分号 () CREATE OR REPLACE TRIGGER 部门_ID BEFORE INSERT OR DELETE OR UPDATE ON create_user_name.部门 FOR EACH ROW DECLARE nid NUMBER; BEGIN IF INSERTING THEN SELECT NVL((MAX(ID)+1),1) INTO nid FROM create_user_name.部门; :new.ID := nid; ELSIF UPDATING THEN :new.ID := :old.ID; ELSIF DELETING THEN NULL; END IF; END; / . . .
CREATE OR REPLACE TRIGGER 部门_ID
BEFORE INSERT OR DELETE OR UPDATE ON create_user_name.部门
FOR EACH ROW
DECLARE
nid NUMBER;
BEGIN
IF INSERTING THEN
SELECT NVL((MAX(ID)+1),1) INTO nid FROM create_user_name.部门;
:new.ID := nid; ELSIF UPDATING THEN
:new.ID := :old.ID; ELSIF DELETING THEN
NULL; END IF;
END;
/
.
.
.