which will fire first ? Trigger or Constraint

Answer Posted / keshavenas

The sequence of execution as follows :
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

Can I copy :old and :new pseudo-records in/to an oracle stored procedure?

871


Mention what problem one might face while writing log information to a data-base table in pl/sql?

871


What are the different types of joins in sql?

1150


define sql delete statement ? : Sql dba

745


How do I create a sql database?

710






What is record variable?

708


List the various privileges that a user can grant to another user?

774


how can you create an empty table from an existing table? : Sql dba

858


Explain the working of primary key?

839


Can we join tables without foreign key?

693


Can we rollback truncate?

719


Define union, minus, union all, intersect ?

738


How to load data with sql*loader?

745


Where is all the data on the internet stored?

734


What is t-sql? : Transact sql

711