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 the disadvantages of not performing database normalization?
Can you have a foreign key without a primary key?
What is the difference between the implicit and explicit cursors?
Explain mutating table error.
What is the difference between drop and truncate commands?
how to include comments in sql statements? : Sql dba
What is the use of pl/sql table?
How to convert comma separated string to array in pl/sql?
How many types of tables are there?
What is query execution plan in sql?
What is anonymous block in sql?
How is use pl and sql?
What is Difference Between Unique and Primary Key Constraints?
What is pl sql block in dbms?
mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql
