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
How delete all records from table in sql?
What does (+) mean in sql joins?
what are the drivers in mysql? : Sql dba
What are pl sql procedures?
What is a null value?
How to download oracle sql developer?
What is a trigger in sql?
What are the properties of a transaction?
How can I make sql query run faster?
what is innodb? : Sql dba
what is log shipping? : Sql dba
What does 0 mean in sql?
what is a constraint? : Sql dba
Can we perform dml on view?
What is the difference between python and sql?
