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
Name different methods for getting streams.
Can I enable requests to a jdbc connection pool for a database connection to wait until a connection is available?
How do we load the drivers?
Why are we using blob datatypes in jdbc?
How can we retrieve the file in the oracle database?
How can you make a connection?
What is the meaning of “dirty read” in the database?
What is getconnection method in java?
What protocol does jdbc use?
Result set’s index starts with 0 or 1?
Explain different types of locks in jdbc?
What is execute in java?
Explain the life cycle of jdbc.
What is JDBC Batch Processing and what are it’s benefits?
What is device controller?