Oracle ENABLE Trigger

The ALTER TRIGGER statement is used to enable a trigger.

Syntax

snippet
ALTER TRIGGER trigger_name ENABLE;

Parameters

trigger_name: It specifies the name of the trigger that you want to enable.

Oracle ENABLE Trigger Example

snippet
ALTER TRIGGER SUPPLIERS_T1 ENABLE;

This example will enable the trigger named "SUPPLIERS_T1" in the "SUPPLIERS" table.

Oracle Enable trigger

Oracle ENABLE ALL Triggers Example

Syntax

snippet
ALTER TABLE table_name ENABLE ALL TRIGGERS;

Example

snippet
ALTER TABLE SUPPLIERS ENABLE ALL TRIGGERS;

This example will enable all the triggers on the table name "SUPPLIERS".

Oracle Enable trigger 2
Related Tutorial
Follow Us
https://www.facebook.com/Rookie-Nerd-638990322793530 https://twitter.com/RookieNerdTutor https://plus.google.com/b/117136517396468545840 #
Contents +