which will default fire first 
statement level trigger or row level trigger

Answer Posted / ram

Before Insert/update/delete triggers executes first..
In this statement level triggers execute first..the order flows as below
Statement level -- before trigger
row level -- before trigger
row level -- after Insert/update/delete triggers
statement level -- after Insert/update/delete triggers

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

where are cookies actually stored on the hard disk? : Sql dba

578


how can we repair a mysql table? : Sql dba

538


Which is better stored procedure or query?

546


Is vs as in pl sql?

491


Can we create view in stored procedure?

524






What are the differences between implicit and explicit cursors?

517


What is the difference between a procedure and a function?

494


Is not equal in sql?

566


What is cross join example?

551


What will you get by the cursor attribute sql%rowcount?

549


What is relationship? How many types of relationship are there?

590


what is 'trigger' in sql? : Sql dba

557


What is the execution plan in sql?

555


What is embedded sql in db2?

507


What is coalesce sql?

513