which will fire first ? Trigger or Constraint
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
Can we insert in view in sql?
What are the popular database management systems in the it industry?
What is offset and limit in sql?
What will you get by the cursor attribute sql%found?
How do I view a view in sql?
What are the ddl commands?
What is the requirement of self-join?
What is sql in oracle?
What is a natural join?
How to select the Nth maximum salary from Table Emp in Oracle SQL Plus ?
How to get unique records from a table?
How many sql are there?
what is a database transaction? : Sql dba
What do you mean by table in sql?
What is coalesce in sql?