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


Please Help Members By Posting Answers For Below Questions

What is ceil and floor in oracle?

826


What is the parameter mode that can be passed to a procedure?

815


How to delete multiple rows from a table in oracle?

820


What is varray?

813


Explain about achiever in sql?

812


What are the most common interview questions on ETL Testing for experience?

886


What happens in oracle commit?

784


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 ?

2066


What are the differences between interval year to month and interval day to second?

788


What are the uses of Database Trigger ?

1367


Explain the use of consistent option in exp command.

761


List out the components of logical database structure of oracle database.

819


How do I start tns listener?

795


What is clustered table in Oracle?

869


How to convert raw data type into text in oracle? Explain

815