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.
- 2 Answers
- 3873 Views
- Maruti Suzuki, I also Faced
- E-Mail Answers
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 mdb stand for?
how to concatenate two character strings? : Sql dba
List and explain the different types of join clauses supported in ansi-standard sql?
How do you declare a constant?
What are two statement types in sql?
what are the advantages of sql ? : Sql dba
Inline the values in PL/SQL, what does it mean.?
Is null operator in sql?
Which normal form is best?
What is sql and db2?
Does oracle use sql?
What is sql query limit?
How many clustered indexes can be created on a table?
is mysql query is case sensitive? : Sql dba
How do I partition a table in sql?
