oracle enable disable trigger

Solutions on MaxInterview for oracle enable disable trigger by the best coders in the world

we are a community of more than 2 million smartest coders
registration for
employee referral programs
are now open
get referred to google, amazon, flipkart and more
register now
  
pinned-register now
showing results for - "oracle enable disable trigger"
Cruz
23 Mar 2019
1ALTER TRIGGER my_trigger ENABLE;
2ALTER TRIGGER my_trigger DISABLE;
3-- Associated with a table:
4ALTER TABLE my_trigger ENABLE ALL TRIGGERS;
5ALTER TABLE my_trigger DISABLE ALL TRIGGERS;