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 is exception handling handled in mysql? : Sql dba
Is sql sequential or random?
Is ms sql is free?
Is sql an operating system?
How can one get sql*loader to commit only at the end of the load file? : aql loader
What are tables in sql?
Can a key be both primary and foreign?
How can you load multi line records? : aql loader
Why is sql better than hql?
What is pl sql block structure?
how to get a list of columns in an existing table? : Sql dba
Can you have a foreign key without a primary key?
what are the advantages a stored procedure? : Sql dba
What is data abstraction in sql?
Is sqlexception checked or unchecked?