Answers for "disable all triggers in oracle"

SQL
1

oracle enable disable trigger

ALTER TRIGGER my_trigger ENABLE;
ALTER TRIGGER my_trigger DISABLE;
-- Associated with a table:
ALTER TABLE my_trigger ENABLE ALL TRIGGERS;
ALTER TABLE my_trigger DISABLE ALL TRIGGERS;
Posted by: Guest on January-29-2021
0

drop all triggers oracle

select 'drop trigger ' || trigger_name || ';' stmt from user_triggers;
Posted by: Guest on May-28-2020

Code answers related to "SQL"

Browse Popular Code Answers by Language