Interested to Buy Any Domain ? << Click Here >> for more details...
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 are data types in pl sql?
Can we use threading in pl/sql?
What is the purpose of the primary key?
What is the difference between Union and Union all. Which is faster.
Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql
What are the types of join in sql?
How many sql commands are there?
What is the command used to fetch the first 5 characters of a string?
what is 'mysqlshow'? : Sql dba
How do I make my sql query run faster?
What is cross join example?
how can we repair a mysql table? : Sql dba
What are the built in functions of sql?
What is union and union all keyword in sql?
What are stored procedures used for?
