Interested to Buy Any Domain ? << Click Here >> for more details...
which will fire first ? Trigger or Constraint
- 24 Answers
- 50614 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
How do you remove duplicate records from a table?
Is big data nosql?
What pl/sql package consists of?
what is the use of double ampersand (&&) in sql queries?
What is sqlite used for?
How can we connect an Android App to an Oracle database and use the PL/SQL procedural code?
What is a primary key sql?
What is the most restrictive isolation level? : Transact sql
Why is theta join required?
what are the types of join and explain each? : Sql dba
What is left join in sql?
What is difference between nchar and nvarchar?
What are some emotional triggers?
what is bcp? When does it used? : Sql dba
what is sql profiler? : Sql dba
