which will fire first ? Trigger or Constraint
Answer Posted / raj dhar
It is depend upon the condition, as if trigger is written
on after insert and update then constraint will fire first
and if you make a trigger as on before insert or update
then the trigger will fire first.
| Is This Answer Correct ? | 4 Yes | 5 No |
Post New Answer View All Answers
Can a foreign key have a different name?
What is nosql example?
How can you create an empty table from an existing table?
What is record type in pl sql?
Define join and name different types of joins?
What is the purpose of my sql?
What are the operators in sql?
Difference between table function and pipelined function?
Explain sql data types?
What is mutating trigger?
What is meaning of <> in sql?
What are instead of triggers?
Is sql between inclusive?
What are different functions in sql?
What is PL/SQL Records?