oracle enable disable trigger 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;