Oracle 触发器的使用小结

--建递增序列

CREATE SEQUENCE LZEAM_SP_LOOP_EQ_SEQ MINVALUE 1 INCREMENT BY 1 START WITH 1

测试:

SELECT LZEAM_SP_LOOP_EQ_SEQ.NEXTVAL FROM DUAL

--建触发器

CREATE OR REPLACE TRIGGER LZEAM.LZEAM_SP_LOOP_EQ_TRIGGER BEFORE INSERT ON SP_LOOP_EQ FOR EACH ROW BEGIN SELECT LZEAM.LZEAM_SP_LOOP_EQ_SEQ.NEXTVAL INTO :NEW.LOOP_EQ_CODE FROM DUAL; END;

--查触发器

SELECT * FROM USER_TRIGGERS;

/**启/禁用触发器*/

ALTER TABLE SP_LOOP_EQ DISABLE ALL TRIGGERS ALTER TABLE SP_LOOP_EQ ENABLE ALL TRIGGERS