Answer Posted / arvind pandita
In simple words Instead of Trigger is used to update base
tables through view based on base table.
This prevets us to update multiple tables in case of an
Complex view.
| Is This Answer Correct ? | 19 Yes | 7 No |
Post New Answer View All Answers
How do I know if I have sql express or standard?
What does the argument [or replace] do?
How to get each name only once from an employee table?
what is union? : Sql dba
is it possible to pass an object or table to a procedure as an argument?
What is a mutating table and a constraining table?
What are different types of triggers?
What are stuff and replace function?
How to run sql commands in sql*plus?
How to avoid using cursors?
What is record variable?
how can we repair a mysql table? : Sql dba
what is the difference between a local and a global temporary table? : Sql dba
how to create a new view in mysql? : Sql dba
How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?