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 are nested tables?
how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....
How to delete all rows a table in oracle?
What is tns service name?
In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??
In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?
Can sub procedure/function be called recursively?
How do I use unicode codesets with the weblogic jdriver for oracle driver?
How to execute a stored procedure in oracle?
How to write a query with a right outer join in oracle?
What is an oracle user account?
What is format trigger?
How to download oracle database 10g xe?
What are the arithmetic operations?
Can select statements be used on views in oracle?