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.
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / abhishek jee
Please provide details on the contents of the triggers. That way, we will be able to figure out what the triggers do and how many times they would execute.
| Is This Answer Correct ? | 0 Yes | 0 No |
Can you call pl/sql package functions from within a fast formula?
What is index example?
what is the difference between union and union all? : Sql dba
Is natural join same as inner join?
What is meant by <> in sql?
what is acid property in database? : Sql dba
How do I view output in sql developer?
What is sql table?
What are the two types of periodical indexes?
What can I use instead of union in sql?
How does one load ebcdic data? : aql loader
How to create a table using constraints... IF i change the PARENT KEY value ,then CHILD KEY table will also to change in the another table... plz reply ur answers @ mak2786@gmail.com Arunkumar
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)