which will fire first ? Trigger or Constraint
Answer Posted / radha sri seshu.kolla
I THINK TRIGGER FIRES FIRST, BCZ WHEN U WRITE A TRIGGER
LIKE 'BEFORE INSERT ON EMP' EVENT. THIS TRIGGER WILL FIRE
IMMEDEATELY BEFORE THE DATA IS ABOUT TO INSERT IN THE
TABLE.WHERE AS IN THE CASE OF CONSTRAINTS, WHEN YOU INSERT
THE DATA,THE DATA GOES FOR CONSTRAINT VALIDATION THEN THE
DATA WILL BE REJECTED(IF THE DATA VIOLATES THE CONSTRAINT
RULE). I AM NOT 100% SURE. THIS IS JUST MY IMAGINATION.
Is This Answer Correct ? | 11 Yes | 5 No |
Post New Answer View All Answers
How do I view a procedure in sql?
How to select random rows from a table?
what is self join and what is the requirement of self join? : Sql dba
Show how functions and procedures are called in a pl/sql block.
what is dbms? : Sql dba
What is composite data type in pl sql?
Does view contain data?
What is the least restrictive isolation level? : Transact sql
What is procedure and function in sql?
Differentiate between sga and pga.
Where is all the data on the internet stored?
what are all different types of collation sensitivity? : Sql dba
What are the properties of a transaction?
What is the difference between nested table and varray?
What is sql constant?