Maximum how many triggers can be updated in table ?
Answer Posted / khushal
The oracle table can have the 12 Trigger associated with it.
-- before constraints are applied
1) BEFORE INSERT STATEMENT LEVEL
2) BEFORE INSERT ROW LEVEL
3) BEFORE UPDATE STATEMENT LEVEL
4) BEFORE UPDATE ROW LEVEL
5) BEFORE DELETE STATEMENT LEVEL
6) BEFORE DELETE ROW LEVEL
7) AFTER INSERT STATEMENT LEVEL
8) AFTER INSERT ROW LEVEL
9) AFTER UPDATE STATEMENT LEVEL
10) AFTER UPDATE ROW LEVEL
11) AFTER DELETE STATEMENT LEVEL
12) AFTER DELETE ROW LEVEL
Is This Answer Correct ? | 15 Yes | 2 No |
Post New Answer View All Answers
What is ceil and floor in oracle?
What is the parameter mode that can be passed to a procedure?
How to delete multiple rows from a table in oracle?
What is varray?
Explain about achiever in sql?
What are the most common interview questions on ETL Testing for experience?
What happens in oracle commit?
If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?
What are the differences between interval year to month and interval day to second?
What are the uses of Database Trigger ?
Explain the use of consistent option in exp command.
List out the components of logical database structure of oracle database.
How do I start tns listener?
What is clustered table in Oracle?
How to convert raw data type into text in oracle? Explain