Summary: in this tutorial, you will learn how to enable a trigger or all triggers of a table in the database.
Enable a trigger
To enable a previously disabled trigger, you use the ALTER TRIGGER ENABLE statement:
ALTER TRIGGER trigger_name ENABLE;
In this syntax, you place the name of the trigger that you want to disable after the ALTER TRIGGER keywords.
For example, the following statement enables the customers_audit_trg trigger:
ALTER TRIGGER customers_audit_trg ENABLE;
Once the trigger is enabled, you can see its color changes from gray to orange:
Enable all triggers of a table
To enable all triggers of a table, you can use the ALTER TABLE ... ENABLE ALL TRIGGERS statement:
ALTER TABLE table_name
ENABLE ALL TRIGGERS;
In this syntax, you put the name of the table in which you want to enable all triggers.
For example, this statement enables all triggers of the customers table:
ALTER TABLE customers
ENABLE ALL TRIGGERS;
In this tutorial, you have learned how to enable a trigger or all triggers of a table in the Oracle Database.