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

Adblocker detected! Please consider reading this notice.

We've detected that you are using AdBlock Plus or some other adblocking software which is preventing the page from fully loading.

We don't have any banner, Flash, animation, obnoxious sound, or popup ad. We do not implement these annoying types of ads!

We need money to operate the site, and almost all of it comes from our online advertising.

Please add wikitechy.com to your ad blocking whitelist or disable your adblocking software.

×