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.
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!