SQL语句_设置序列和触发器

CREATE SEQUENCE SEQ_DEPARTMENT
minvalue 1 
maxvalue 99999999 
start with 1 
increment by 1
nocache order;

CREATE OR REPLACE TRIGGER DEPARTMENT_AUTOINCREMENT
BEFORE INSERT ON DEPARTMENT
FOR EACH ROW
WHEN (NEW.DEP_ID IS NULL)
BEGIN
SELECT SEQ_DEPARTMENT.NEXTVAL INTO :NEW.DEP_ID FROM DUAL;
END;

CREATE SEQUENCE SEQ_POINT
minvalue 1 
maxvalue 99999999 
start with 1 
increment by 1
nocache order;

CREATE OR REPLACE TRIGGER POINT_AUTOINCREMENT
BEFORE INSERT ON POINT
FOR EACH ROW
WHEN (NEW.POINT_ID IS NULL)
BEGIN
SELECT SEQ_POINT.NEXTVAL INTO :NEW.POINT_ID FROM DUAL;
END;