Answer Posted / k. a. purushotham
Basically there are three types of triggers,
Row and statement triggers
Before and after triggers
Insteadof triggers
Possible combination of these triggers
Before row trigger
After row trigger
Before statement trigger
After statement trigger
Instead of trigger is mainly for a view.
if we want to write a trigger in such a way that the
trigger action is to be on underlying base tables of a view,
when an DML statement (insert,update,delete)is issued
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is jdbc and jpa?
What is the benefit of having jdbcrowset implementation? Why do we need a jdbcrowset like wrapper around resultset?
What does the jdbc connection interface?
What is jdbc odbc driver?
What are the 4 types of jdbc drivers?
Is jdbc open source?
How can we execute stored procedures?
Where is ojdbc14 jar located?
What is statement and preparedstatement in java?
What is jdbc in java?
What is jdbc driver?
What packages are used by jdbc?
What is database deadlock ? How can we avoid them?
What are the utilities of the callablestatement?
What is difference between odbc and jdbc?