Answer Posted / sanjay
Using Instead of Trigger, you can restore the deleted
record.
Its primary use can be when you accidentally delete a
record from a table. In case of Instead of trigger the view
doesn't get updated and hence the deleted record can be
retrieved.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Does view store data in sql?
How does a covering index work?
Is natural join and inner join same?
define sql delete statement ? : Sql dba
What are the parts of a sql statement?
What is the maximum number of columns in sql table?
what is subquery? : Sql dba
What is pl sql variable?
How do you write a subquery?
What are the uses of sysdate and user keywords?
Where the sql database files are stored?
Is like operator in sql case sensitive?
Explain ddl statements in pl/sql?
Is it possible to pass parameters to triggers?
What does := mean in pl sql?