Diff. types of triggers..
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / pratap
There are mainily 3 types of triggers
1> DML Trigger
2> Instead of Trigger written on only view
3> System Trigger
DML Trigger written on table that gets fired on DML events
like
insert or delete or update operation
that trigger may fire
1> After dml event
2> Before dml event these are timings for trigger firing
Instead of trigger written only on view that view is not
modifiable that also gets fired
when dml event occurs
System trigger gets fired on system event like
before log off or after log on or before shutdown
this trigger may be written on
Database level
Schema level
Is This Answer Correct ? | 0 Yes | 2 No |
Answer / dev
static trigger
the icon or window background is clicked or double-clicked
without moving the mouse
dynamic trigger
the icon is dragged and dropped onto another icon or window
background
hold trigger
the mouse button is held down on an icon or window background
Is This Answer Correct ? | 2 Yes | 5 No |
What are the steps involved in establishing a connection using jdbc in java?
What is static Synchronized method in JDBC API? Give an example?
3 Answers 3 Edge Solutions, R Systems, Sirvisetti Global Services,
What is Type-1 Driver and when this driver is used?
What are the different types of interfaces in the api component?
How do we call a stored procedure from jdbc?
What type of drivers are used for web application?
Is jdbc connection secure?
is java pure object oriented or not ?
What is jdbc driver?
What does the jdbc databasemetadata interface?
Name the new features added in jdbc 4.0.
What are JDBC statements?