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 a schema sql?
What is sql analyzer?
Is left join same as inner join?
Explain the methods used to protect source code of pl/sql.
How do you declare a user-defined exception?
What is the syntax and use of the coalesce function?
What are commit, rollback, and savepoint?
What is a rank in sql?
What are the usages of sql?
what are enums used for in mysql? : Sql dba
How can you view the errors encountered in a trigger?
Why having clause is used in sql?
What are inner and outer joins examples of both?
What is foreign key and example?
How does sql developer connect to oracle database?