Interested to Buy Any Domain ? << Click Here >> for more details...
which will fire first ? Trigger or Constraint
- 24 Answers
- 51376 Views
- i2, IBM, I also Faced
- E-Mail Answers
Answer Posted / anilbabu makkena
It is on the based situation.
1st situation CONSTRAINT and BEFORE STATEMENT Level TRIGGER
and BEFORE ROW Level TRIGGER Created.
1.BEFORE STATEMENT Level TRIGGER Fires.
2.BEFORE ROW Level TRIGGER Fires.
3.CONSTRAINT Fires.
2nd situation CONSTRAINT and AFTER STATEMENT Level TRIGGER
and AFTER ROW Level TRIGGER Created.
1.CONSTRAINT fires.
2.AFTER ROW Level TRIGGER Fires.
3.AFTER STATEMENT Level TRIGGER Fires.
3rd situation CONSTRAINT and BEFORE STATEMENT Level TRIGGER
and BEFORE ROW Level TRIGGER and AFTER ROW Level TRIGGER and
AFTER STATEMENT Level TRIGGER Created.
1.BEFORE STATEMENT Level TRIGGER Fires.
2.BEFORE ROW Level TRIGGER Fires.
3.CONSTRAINT Fire.
4.AFTER ROW Level TRIGGER Fires.
5.AFTER STATEMENT Level TRIGGER Fires.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What is consistency?
what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba
What are the three forms of normalization?
How to run pl sql program in mysql?
Do stored procedures prevent sql injection?
what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba
How exception is different from error?
What are the differences between in and exists clause?
What does select count (*) mean in sql?
What is difference between db2 and sql?
Mention what is the plv (pl/vision) package offers?
Where is pl sql used?
what is csv? : Sql dba
What are the various restrictions imposed on view in terms of dml?
What is the use of double ampersand (&&) in sql queries? Give an example
