Answer Posted / chandrakant agrawal
To recompile Trigger:
ALTER TRIGGER <trigger_name> COMPILE;
The trigger can be enabled and disabled manually by using:
Alter Table <table_name> disable(enable) all trigger;
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
What is query syntax?
What is pl sql in dbms?
What is sql data?
How to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?
What is cold data?
what tools available for managing mysql server? : Sql dba
What is the requirement of self-join?
Is time a data type in sql?
Is t sql a programming language?
what is view? : Sql dba
what's the difference between a primary key and a unique key? : Sql dba
What is rename in sql?
How many functions are there in sql?
what are the advantages of sql ? : Sql dba
What is trigger with example?