There are 5 records in a table and we have implemented two triggers that are :pre_query and post_query how many times these triggers will fire.
Answer Posted / dinesh
This is depends on which type of trigger we have create.If Statement level then it will fire 2 times and for row level it will fire 10 time maximum and depends on number of record updated.
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
What is left join in postgresql?
what is the difference between clustered and non clustered index in sql? : Sql dba
What are the sql aggregate functions?
what's the difference between a primary key and a unique key? : Sql dba
How do you use a while loop in pl sql?
How does an execution block start and end in pl sql?
Explain the difference between rename and alias?
What is cascade in sql?
Does truncate free space?
What is record in pl sql?
What is the main difference between sql and pl/sql?
What are dml commands?
Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?
What do you mean by dbms? What are its different types?
Is pl sql useful?