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
Can we insert delete data in view?
Differentiate between % rowtype and type record.
what is subquery? : Sql dba
Can you load data into multiple tables at once? : aql loader
Is primary key clustered index?
What is the difference between an inner join and an outer join?
What is rtm in testing?
what is union, minus and interact commands? : Sql dba
what is the difference between primary key and unique key? : Sql dba
Which join is like inner join?
What is user defined functions?
what is index? : Sql dba
Is sql procedural language?
How do you remove duplicate records from a table?
what are all types of user defined functions? : Sql dba