CREATE SEQUENCE CMPO_PUSH_SEQ
MINVALUE 1
NOMAXVALUE
START WITH 1
INCREMENT BY 1
NOCYCLE
NOCACHE;
CREATE OR REPLACE TRIGGER CMPO_PUSH_TRIGGER BEFORE INSERT ON CMPO_PUSH FOR EACH ROW WHEN(NEW.PUSH_ROW_ID IS NULL)
BEGIN
SELECT CMPO_PUSH_SEQ.NEXTVAL INTO:NEW.PUSH_ROW_ID FROM dual;
END;
建Oracle主键自增序列,没错插入自增1