84
Oracle DISABLE Trigger
The ALTER TRIGGER statement is used to disable a trigger.
Syntax
Parameters
trigger_name: It specifies the name of the trigger that you want to disable.
Oracle DISABLE Trigger Example
This example will disable the trigger called “SUPPLIERS_T2” from the table “SUPPLIERS”.
Oracle DISABLE ALL Triggers Example
If there is more than one trigger in a table and you want to disable all the triggers from the database then you can do it by ALTER TABLE statement.
Syntax
Example
This example will disable all triggers from the table “suppliers”.
Next TopicOracle Enable Trigger