Sign Up Login


  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

which will fire first ? Trigger or Constraint

Question Posted / anilbabu makkena

Answer Posted / anilbabu makkena

It is on the based situation.
1st situation CONSTRAINT and BEFORE STATEMENT Level TRIGGER
and BEFORE ROW Level TRIGGER Created.

1.BEFORE STATEMENT Level TRIGGER Fires.
2.BEFORE ROW Level TRIGGER Fires.
3.CONSTRAINT Fires.

2nd situation CONSTRAINT and AFTER STATEMENT Level TRIGGER
and AFTER ROW Level TRIGGER Created.

1.CONSTRAINT fires.
2.AFTER ROW Level TRIGGER Fires.
3.AFTER STATEMENT Level TRIGGER Fires.

3rd situation CONSTRAINT and BEFORE STATEMENT Level TRIGGER
and BEFORE ROW Level TRIGGER and AFTER ROW Level TRIGGER and
AFTER STATEMENT Level TRIGGER Created.

1.BEFORE STATEMENT Level TRIGGER Fires.
2.BEFORE ROW Level TRIGGER Fires.
3.CONSTRAINT Fire.
4.AFTER ROW Level TRIGGER Fires.
5.AFTER STATEMENT Level TRIGGER Fires.

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?

3311

what is sql profiler? : Sql dba

793

what is the difference between cluster and non cluster index? : Sql dba

730

How can you select unique records from a table?

701

How much does sql certification cost?

745




Why do we need databases?

730

How many types of index are there?

724

Is left join same as inner join?

723

What are hotfixes and patches?

691

What is a call statement? Explain with an example.

745

Can you load data into multiple tables at once? : aql loader

800

What are types of joins?

703

Is primary key clustered or nonclustered?

741

Does sql view stored data?

722

What is not null in sql?

781