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


Please Help Members By Posting Answers For Below Questions

what is data control language? : Sql dba

597


What are types of exception?

544


Explain the purpose of %type and %rowtype data types?

513


What is difference between pl and sql?

543


how to select unique records from a table? : Sql dba

640






What are sql commands?

511


What is %type in pl sql?

551


what are numeric data types? : Sql dba

588


What is triggering circuit?

604


What is bind reference and how can it be created?

588


Explain the working of foreign key?

557


What if we write return in procedure?

794


define sql update statement ? : Sql dba

594


How to write html code in pl sql?

588


What are pl/sql cursors?

575