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
What do you mean by query optimization?
Name three sql operations that perform a sort.
How is a process of pl/sql compiled?
What is query optimization in sql?
What is sql character function?
What is integrity in sql?
What do you mean by field in sql?
what tools available for managing mysql server? : Sql dba
What are literals in sql server?
how to check myisam tables for errors? : Sql dba
what happens when the column is set to auto increment and you reach the maximum value for that table? : Sql dba
What is the purpose of primary key?
When can we use the where clause and the having clause?
What is a design view?
What is the use of & in pl sql?