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
What are user defined functions?
Explain the purpose of %type and %rowtype data types?
When is the update_statistics command used?
How do you write a subquery?
What is latest version of sql?
What are all types of user defined functions?
Which is faster joins or subqueries?
What is scalar function in sql?
how to calculate the difference between two dates? : Sql dba
Why we use triggers in mysql?
List the various privileges that a user can grant to another user?
What are types of exception?
How do I view output in sql developer?
Does truncate require commit?
What are different types of triggers?