What is the syntax for disabling a trigger?

Options
- DISABLE TRIGGER trigger_name;
- ALTER TRIGGER trigger_name DISABLE;
- Both a an b can be used
- ALTER TRIGGER DISABLE trigger_name;

CORRECT ANSWER : ALTER TRIGGER trigger_name DISABLE;

Discussion Board
ALTER TRIGGER trigger_name DISABLE;

A disabled trigger does not execute its trigger body, even if a triggering statement is issued and the trigger restriction (if any) evaluates to true. To enable or disable triggers using the ALTER TABLE statement, you must own the table, have the ALTER object privilege for the table, or have the ALTER ANY TABLE system privilege. To enable or disable an individual trigger using the ALTER TRIGGER statement, you must own the trigger or have the ALTER ANY TRIGGER system privilege.

Prajakta Pandit 02-15-2017 04:03 AM

pl/sql

need for interview

krupa 08-20-2014 06:10 AM

Write your comments


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)


Related Content

Advertisement
 
▲