How to close trigger in oracle

Oracle method to close triggers: 1. Use the "alter table table name disable all triggers;" statement to close all triggers in the table; 2. Use the "alter trigger trigger name disable;" statement to close the specified trigger.

The operating environment of this tutorial: Windows 10 system, Oracle 11g version, Dell G3 computer.

How to turn off triggers in oracle

1. Disable all triggers (triggers) in the specified table

Syntax:

alter table 表名 disable all triggers;

The example is as follows:

alter table table_name disable all triggers;

2. Disable the specified trigger (trigger)

Syntax:

alter trigger 触发器名 disable;

The example is as follows:

alter trigger trigger_name disable;

Extended knowledge:

Enable all triggers in the specified table

Syntax:

alter table 表名 enable all triggers;

Examples are as follows:

alter table table_name enable all triggers;

Enable specified trigger (trigger)

Syntax:

alter trigger 触发器名 enable;

The example is as follows:

alter trigger trigger_name enable;

Recommended tutorial: "OracleVideoTutorial》

The above is the detailed content of How to close trigger in oracle. For more information, please follow other related articles on the PHP Chinese website!