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


Please Help Members By Posting Answers For Below Questions

What are the types of subqueries?

772


Does truncate remove indexes?

723


Why primary key is required?

723


What is sql profiling in oracle?

739


Explain the working of foreign key?

729






Explain the working of primary key?

839


How we can update the view?

814


How many primary keys can a table have?

724


Why use truncate instead of delete?

721


What does the hierarchical profiler does?

755


define data blocks ? : Sql dba

736


how to return query output in html format? : Sql dba

853


Is mariadb nosql?

773


What is the most common sql injection tool?

740


What is cursor in pl sql with examples?

674