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 do you understand by DDL and DML statements?
Explain how to make updates to the updatable resultsets.
What is represented by the connection object?
Is uri the same as url?
How can I determine the isolation levels supported by my DBMS?
How to use JDBC to connect Microsoft Access?
What does jdbc setmaxrows method do?
Which of the attributes in the monitoring tab for a jdbc connection pool in the administrative console tell us how many clients are currently waiting for a connection?
What are the advantages of using preparedstatement in java?
How to check jdbc connection in linux?
What is meant by dao?
What is jdbc odbc in java?
Why isn't the java.sql.DriverManager class being found?
Can resultset be null in java?
What is JDBC PreparedStatement?