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
Give an example for getXXX method?
What do you understand by jdbc datasource?
Differentiate between a statement and a preparedstatement.
Why did my jdbc code throw a rollback sqlexception?
What is jdbc in java?
What is DML?
How can we retrieve the file in the oracle database?
Is java a database?
How to achieve JDBC Connection Pooling using JDBC DataSource and JNDI in Apache Tomcat Server?
What is the function of drivermanager class?
What is jdbc and why is it required?
Does the JDBC-ODBC Bridge support multiple concurrent open statements per connection?
What are jdbc?
What is the return type of class.forname() method?
Can resultset be null in java?
