將觸發(fā)器應(yīng)用在插入表時相應(yīng)字段唯一值
–建遞增序列
CREATE SEQUENCE LZEAM_SP_LOOP_EQ_SEQ MINVALUE 1 INCREMENT BY 1 START WITH 1
測試:
SELECT LZEAM_SP_LOOP_EQ_SEQ.NEXTVAL FROM DUAL
–建觸發(fā)器
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;
–查觸發(fā)器
SELECT * FROM USER_TRIGGERS;
/**啟/禁用觸發(fā)器*/
ALTER TABLE SP_LOOP_EQ DISABLE ALL TRIGGERS ALTER TABLE SP_LOOP_EQ ENABLE ALL TRIGGERS
? 版權(quán)聲明
文章版權(quán)歸作者所有，未經(jīng)允許請勿轉(zhuǎn)載。
THE END
