Oracle DISABLE Trigger

The ALTER TRIGGER statement is used to disable a trigger.

Syntax

snippet
ALTER TRIGGER trigger_name DISABLE;

Parameters

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

Oracle DISABLE Trigger Example

snippet
ALTER TRIGGER SUPPLIERS_T2 DISABLE;

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

snippet
ALTER TABLE table_name DISABLE ALL TRIGGERS;

Example

snippet
ALTER TABLE SUPPLIERS DISABLE ALL TRIGGERS;

This example will disable all triggers from the table "suppliers".

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