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 different categories of sql commands?
what is oltp (online transaction processing)? : Sql dba
Is left join faster than inner join?
Is like operator in sql case sensitive?
What are pl sql procedures?
What are the limitations of sql express?
What is cursor explain with example?
Where can I learn sql for free?
what is union, minus and interact commands? : Sql dba
Is it possible to create the following trigger: before or after update trigger for each row?
Why partition by is used in sql?
First round ------------------- - Procedure - Packages - Views - Virtual tables - Can we use dcl with in function? - Joins and few scenarios - Triggers and its type - Pragma, type and its functionality - How to create db link in oracle - Materialized view - How to find duplicate values from table? - Cursor and its functionality - Write a script to display friday and its date from a entire year. - Exception Handling Second round ------------------------ Gave a scenario like. Need to write a function to perform. When user try to change a password. It must not be last five password and a given password can be combination of characters, symbols, upper and lower case.
Which is better join or subquery?
Is a secondary key the same as a foreign key?
how to get a list of columns in an existing table? : Sql dba
