Summary of use of Oracle triggers

-- Build an increasing sequence
CREATE SEQUENCE LZEAM_SP_LOOP_EQ_SEQ MINVALUE 1 INCREMENT BY 1 START WITH 1
Testing:
SELECT LZEAM_SP_LOOP_EQ_SEQ.NEXTVAL FROM DUAL
-- Build triggers
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;
-- Check triggers
SELECT * FROM USER_TRIGGERS;
/** Activate/disable trigger */
ALTER TABLE SP_LOOP_EQ DISABLE ALL TRIGGERS ALTER TABLE SP_LOOP_EQ ENABLE ALL TRIGGERS