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 an index associated with a constraint?

771


How to loop through a cursor variable?

799


Give the constructs of a package, function or a procedure.

792


What is the difference between primary key and unique key and foreign key in oracle?

762


Describe varray?

838


How to connect asp pages to oracle servers?

783


How would you change old and new values in an insert, delete and update triggers?

772


What is raw datatype in oracle?

808


How to use "while" statements in oracle?

948


What is the relation of a user account and a schema in oracle?

848


How to run queries on external tables?

787


What are advantages of dateset in datastage?

1987


Can you create a synonym without having a table?

773


What is bulk load in oracle?

828


Hi friends can u send the oracle 9i full version download link?????????????? please reply ?

1632