which will fire first ? Trigger or Constraint
Answer Posted / suthakar
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 ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is data control language? : Sql dba
What are types of exception?
Explain the purpose of %type and %rowtype data types?
What is difference between pl and sql?
how to select unique records from a table? : Sql dba
What are sql commands?
What is %type in pl sql?
what are numeric data types? : Sql dba
What is triggering circuit?
What is bind reference and how can it be created?
Explain the working of foreign key?
What if we write return in procedure?
define sql update statement ? : Sql dba
How to write html code in pl sql?
What are pl/sql cursors?