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
how can you see all indexes defined for a table? : Sql dba
If a cursor is open, how can we find in a pl/sql block?
What is difference between primary and secondary key?
which command using query analyzer will give you the version of sql server and operating system? : Sql dba
What are the parameter modes supported by pl/sql?
What is an emotional trigger?
what is a database lock ? : Sql dba
What are analytic functions in sql?
what is clause? : Sql dba
Explain the structure of pl/sql in brief.
how to fetch common records from two tables? : Sql dba
How do I order by ascending in sql?
How can we make an if statement within a select statement?
Why plvtab is considered as the easiest way to access the pl/sql table?
Can a table contain multiple foreign key’s?