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
- 3411 Views
- Maruti Suzuki, I also Faced
- E-Mail Answers
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 |
What is a call statement? Explain with an example.
How can get second highest salary in sql?
in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.
What is auto increment feature in sql?
How global cursor can be declare with dynamic trigger ?
Why stored procedure is better than query?
What are the types of keys?
What are %type and %rowtype for?
what are the non-standard sql commands supported by 'mysql'? : Sql dba
What is a boolean in sql?
What are the query optimization techniques?
Is delete faster than truncate?
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
