Pl sql disable trigger

ALTER TRIGGER trigger_name DISABLE;
ALTER TRIGGER trigger_name ENABLE;

ALTER TABLE table_name DISABLE ALL TRIGGERS;
ALTER TABLE table_name ENABLE ALL TRIGGERS;

Similar codes

4 votes289 views1 answer
Sql quote in string
SQL
1 vote276 views1 answer
Create temporal table in sql
SQL
20 votes326 views4 answers
How to find average in sql
SQL
0 vote295 views1 answer
Como hacer una consulta de un registro que no esta en una tabla en mysql
SQL
5 votes276 views1 answer
Mysql get last day of month
SQL
1 vote287 views1 answer
Oracle drop chain step
SQL
21 votes316 views6 answers
Update sql
SQL
1 vote293 views1 answer
Rails run native ssql query
SQL
0 vote279 views1 answer
Configure: error: Cannot find libpq-fe.h. Please specify correct PostgreSQL installation path
SQL
1 vote287 views1 answer
Oracle grant on all tables in schema
SQL