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 are the exceptions in jdbc?
any one can explain about policy file rule? when i connect database with applet then ther is no compile time error but the run time error is occureed.i.e access is denied.policy file rule is related to this problem.
Why can't I invoke the ResultSet methods afterLast and beforeFirst when the method next works?
How can I determine the isolation levels supported by my DBMS?
How can you know about drivers and database information ?
What is in terms of jdbc a datasource?
What are the different types of lockings in jdbc?
What is JDBC Statement?
What do you understand by DDL and DML statements?
How can I get information about foreign keys used in a table?
Is jdbc a web technology?
What happens if we don't close the connection in jdbc?
How can you load the drivers?
What is the meaning of “dirty read” in the database?
What are the classes and methods used for sending sql statements to database?