What is INSTEAD OF trigger ?

Question Posted / wgk

13 Answers
57691 Views
Hexaware, TCS, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What is INSTEAD OF trigger ?..

Answer / charlyne zeno sohtun

Instead Of Trigger helps in modify a table directly from the
View.

Is This Answer Correct ?

1 Yes

0 No

What is INSTEAD OF trigger ?..

Answer / 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

What is INSTEAD OF trigger ?..

Answer / sardhara piyush

insted of trigget is provied transparant way of modifying
view that can not be modified directly through dmal
statement like(insert,update ane delete)

Is This Answer Correct ?

14 Yes

15 No

Post New Answer