Can we disable a trigger? If yes, how?

Q 33. Can we disable a trigger? If yes, how?

Ans : Yes, we can disable a trigger in PL/SQL. If consider temporarily disabling a trigger and one of the following conditions is true:

1.  An object that the trigger references is not available.
2. We must perform a large data load and want it to proceed quickly without firing triggers.
3. We are loading data into the table to which the trigger applies.
4. We disable a trigger using the ALTER TRIGGER statement with the DISABLE option.
5. We can disable all triggers associated with a table at the same time using the ALTER TABLE statement with the DISABLE ALL TRIGGERS option.

Donate to  grow Studyandupdates

स्टडीएंडअपडेट्स को विकसित करने के लिए  मदत करें

To Provide  more Services among Student

छात्र के बीच अधिक से अधिक  सेवाएं प्रदान करने के लिए