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
What is a sql schema used for?
Why do we use procedures in pl sql?
Does truncate remove indexes?
What is data control language?
What is the difference between truncate and drop statements?
What are the different types of a subquery?
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
How to display the current date in sql?
Why join is faster than subquery?
Why stored procedure is faster than query?
Is postgresql a server?
Explain the insert into statements in sql?
How to move files from one directory to another in pl sql?
What are the types of records?
How do I remove all records from a table?