which will fire first ? Trigger or Constraint

Answer Posted / p.j.mohana rao

Constraint will fire first bcz these are restrict the
column value
before enter into the table these value is valid or not
that why constrint will fire first

Is This Answer Correct ?    9 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a sql schema used for?

546


Why do we use procedures in pl sql?

520


Does truncate remove indexes?

563


What is data control language?

532


What is the difference between truncate and drop statements?

581






What are the different types of a subquery?

523


1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins

1156


How to display the current date in sql?

601


Why join is faster than subquery?

601


Why stored procedure is faster than query?

519


Is postgresql a server?

577


Explain the insert into statements in sql?

569


How to move files from one directory to another in pl sql?

642


What are the types of records?

537


How do I remove all records from a table?

570