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

What are user defined functions?

575


Explain the purpose of %type and %rowtype data types?

499


When is the update_statistics command used?

567


How do you write a subquery?

516


What is latest version of sql?

521






What are all types of user defined functions?

521


Which is faster joins or subqueries?

547


What is scalar function in sql?

525


how to calculate the difference between two dates? : Sql dba

543


Why we use triggers in mysql?

557


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

570


What are types of exception?

530


How do I view output in sql developer?

570


Does truncate require commit?

538


What are different types of triggers?

551