-- 三、创建触发器-- 1.创建 DEPARTMENT ID自增触发器 DEPARTMENT_ID_AUTOINCREASECREATEORREPLACETRIGGER DEPARTMENT_ID_AUTOINCREASE
BEFORE INSERTON DEPARTMENT FOR EACH ROWBEGINSELECT DEPARTMENT_ID.NEXTVAL INTO:NEW.ID FROM dual;END;-- 2.创建 DISTRIBUTE ID自增触发器 DISTRIBUTE_ID_AUTOINCREASECREATEORREPLACETRIGGER DISTRIBUTE_ID_AUTOINCREASE
BEFORE INSERTON DISTRIBUTE FOR EACH ROWBEGINSELECT DISTRIBUTE_ID.NEXTVAL INTO:NEW.ID FROM dual;END;-- 3.创建 STAFF ID自增触发器 STAFF_ID_AUTOINCREASECREATEORREPLACETRIGGER STAFF_ID_AUTOINCREASE
BEFORE INSERTON STAFF FOR EACH ROWBEGINSELECT STAFF_ID.NEXTVAL INTO:NEW.ID FROM dual;END;-- 4.创建 PIPE ID自增触发器 PIPE_ID_AUTOINCREASECREATEORREPLACETRIGGER PIPE_ID_AUTOINCREASE
BEFORE INSERTON PIPE FOR EACH ROWBEGINSELECT PIPE_ID.NEXTVAL INTO:NEW.ID FROM dual;END;-- 5.创建 TRANSFORM ID自增触发器 TRANSFORM_ID_AUTOINCREASECREATEORREPLACETRIGGER TRANSFORM_ID_AUTOINCREASE
BEFORE INSERTON TRANSFORM FOR EACH ROWBEGINSELECT TRANSFORM_ID.NEXTVAL INTO:NEW.ID FROM dual;END;