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
Write the command to remove all players named sachin from the players table.
What is the use of index in hive?
What is a primary key example?
How long it takes to learn pl sql?
What is coalesce sql?
Can we insert data into view?
What are the different types of dbms?
What pl/sql package consists of?
Is primary key clustered or nonclustered?
What is record type in pl sql?
What is the need of merge statement?
Explain constraints in sql?
What is the usage of sql functions?
what is sql profiler? : Sql dba
Why do we use joins in sql?