Summary of the use of Oracle triggers _oracle

--Build incremental sequence
CREATE SEQUENCE lzeam_sp_loop_eq_seq minvalue 1 INCREMENT by 1 START with 1
Test:
SELECT Lzeam_sp_loop_eq_seq. Nextval from DUAL
--building 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;
/**/Disable Trigger * *
ALTER TABLE SP_LOOP_EQ DISABLE all triggers ALTER table sp_loop_eq ENABLE all triggers