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 Data Dictionary Cache in Oracle?
What are the common oracle dba tasks?
What are the predefined tablespaces in a database?
What is a subquery?
How to write a query with an inner join in oracle?
Can we use oracle pl/sql block in core java? if so how? pls get back to me .....
How to use "in" parameter properly?
What is data block in Oracle?
Is oracle a relational database?
6. Display the client name and order date for all orders using the traditional method.
What is a package in oracle?
What is meant by raw datatype?
How to connect to a local oracle 10g xe server?
how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?
What is the string concatenation operator in oracle?