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 an index associated with a constraint?
How to loop through a cursor variable?
Give the constructs of a package, function or a procedure.
What is the difference between primary key and unique key and foreign key in oracle?
Describe varray?
How to connect asp pages to oracle servers?
How would you change old and new values in an insert, delete and update triggers?
What is raw datatype in oracle?
How to use "while" statements in oracle?
What is the relation of a user account and a schema in oracle?
How to run queries on external tables?
What are advantages of dateset in datastage?
Can you create a synonym without having a table?
What is bulk load in oracle?
Hi friends can u send the oracle 9i full version download link?????????????? please reply ?