Oracle Disable Trigger - oracle tutorial - sql tutorial



What is Oracle Disable Trigger ?

  • To enable or disable an individual trigger using the ALTER TRIGGER statement
  • The ALTER TRIGGER statement is used to disable a trigger.

Syntax

ALTER TRIGGER trigger_name DISABLE;   
click below button to copy the code. By - oracle tutorial - team

Parameters

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

Oracle DISABLE Trigger Example

ALTER TRIGGER SUPPLIERS_T2 DISABLE;   
click below button to copy the code. By - oracle tutorial - team
  • 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

ALTER TABLE table_name DISABLE ALL TRIGGERS;   
click below button to copy the code. By - oracle tutorial - team

Example

ALTER TABLE SUPPLIERS DISABLE ALL TRIGGERS;  
click below button to copy the code. By - oracle tutorial - team
  • This example will disable all triggers from the table "suppliers".
 disable trigger

This tutorial provides an indepth knowledge on the following items such as oracle tutorial , sql tutorial , sql , pl sql tutorial , oracle , pl sql , mysql tutorial , learn sql , oracle database tutorial , sql query tutorial , oracle dba tutorial , plsql tutorial , oracle tutorial pdf , oracle pl sql tutorial , oracle sql tutorial , sql tutorial point , oracle tutorial for beginners , learn oracle online free , learn oracle online , learning pl sql programming , learn sql online for free , sql learning online , dba oracle tutorial , oracle sql tutorial advanced , oracle 11g dba tutorial with examples , oracle online learning , oracle learning online , how to learn pl sql , sql coding tutorial , sql learning websites , sql basic learning

Related Searches to Oracle Disable Trigger