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
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
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.