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 compilation error in pl sql?
What is restrict in sql?
What is clause in sql?
What is the difference between delete, truncate and drop command?
Why should I use postgresql?
how to drop an existing table in mysql? : Sql dba
What is the use of sqlerrd 3?
How to call a javascript function from pl sql?
How to avoid using cursors? What to use instead of cursor and in what cases to do so?
What type of join is sql join?
Which tcp/ip port does sql server run?
Can we alter stored procedure?
What are the ddl commands?
what are all the different types of indexes? : Sql dba
What is function and procedure?