which will fire first ? Trigger or Constraint

Answer Posted / srikanth k

The sequence of execution is:
1) before statement level
2) before row level
3) constraint
4) after row level
5) after statement level

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How many aggregate functions are available there in sql?

534


How do you bind variables in pl sql?

584


Are sql connections encrypted?

569


How do I find duplicates in sql?

513


How does one use sql*loader to load images, sound clips and documents? : aql loader

678






What is pl sql record in oracle?

571


What are all ddl commands?

555


What are sql functions? Describe in brief different types of sql functions?

496


What is bind reference and how can it be created?

582


What is the purpose of cursors in pl/sql?

642


How can I delete duplicate rows?

570


What packages(if any) has oracle provided for use by developers?

5041


what are the differences between procedure-oriented languages and object-oriented languages? : Sql dba

514


what is the difference between inner and outer join? Explain with example. : Sql dba

555


What is the main difference between sql and pl/sql?

569