fastread homefastrread library fastread menu

Oracle/PLSQL : Enable all Triggers on a table

Tutorial by:      Date: 2016-04-15 05:24:06

❰ Previous Next ❱

This Oracle tutorial explains how to enable all triggers on a table in Oracle with syntax and examples.

Description

You may have found that you have disabled all triggers on a table and you wish to enable the triggers again. You can do this with the ALTER TRIGGER statement.

Syntax

The syntax to enable all triggers on a table in Oracle/PLSQL is:

ALTER TABLE table_name ENABLE ALL TRIGGERS;

Parameters or Arguments

table_name

The name of the table that all triggers should be enabled on.

Note

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

Example

Let's look at an example that shows how to enable all triggers on a table in Oracle.

For example:

ALTER TABLE orders ENABLE ALL TRIGGERS;

This example uses the ALTER TRIGGER statement to enable all triggers on the table called orders.

 

❰ Previous Next ❱


Oracle/PLSQL

Submit Your Thought, Tutorial, Articls etc.

Submit Your Information India's Number one online promotion website