how to disable trigger in oracle code example
Example: oracle enable disable trigger
ALTER TRIGGER my_trigger ENABLE;
ALTER TRIGGER my_trigger DISABLE;
-- Associated with a table:
ALTER TABLE my_trigger ENABLE ALL TRIGGERS;
ALTER TABLE my_trigger DISABLE ALL TRIGGERS;