fastread homefastrread library fastread menu

Oracle/PLSQL : Disable a Trigger

Tutorial by:      Date: 2016-04-15 05:23:01

❰ Previous Next ❱

This Oracle tutorial explains how to disable a trigger in Oracle with syntax and examples.

Description

Once you have created a Trigger in Oracle, you might find that you are required to disable the trigger. You can do this with the ALTER TRIGGER statement.

Syntax

The syntax for a disabling a Trigger in Oracle/PLSQL is:

ALTER TRIGGER trigger_name DISABLE;

Parameters or Arguments

trigger_name

The name of the trigger that you wish to disable.

Note

  • See also how to disable all triggers on a table.
  • See also how to enable a trigger on a table or enable all triggers on a table.

Example

Let's look at an example that shows how to disable a trigger in Oracle.

For example:

ALTER TRIGGER orders_before_insert DISABLE;

This example uses the ALTER TRIGGER statement to disable the trigger called orders_before_insert.

 

❰ Previous Next ❱


Oracle/PLSQL

Submit Your Thought, Tutorial, Articls etc.

Submit Your Information India's Number one online promotion website