Maximum how many triggers can be updated in table ?

Categories >> Software >> Databases >> Oracle >> Oracle General
Suggest New Category

Question Posted / guest

5 Answers
14515 Views
Accenture, Cap Gemini, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Maximum how many triggers can be updated in table ?..

Answer / 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

Maximum how many triggers can be updated in table ?..

Answer / kavitha

Is This Answer Correct ?

13 Yes

4 No

Maximum how many triggers can be updated in table ?..

Answer / ora

System Privileges Related To Table Triggers
create trigger
create any trigger
administer database trigger
alter any trigger
drop any trigger

Table Trigger Firing Options
-- before constraints are applied
BEFORE INSERT
BEFORE UPDATE
BEFORE DELETE

-- after constraints are applied
AFTER INSERT
AFTER UPDATE
AFTER DELETE

Is This Answer Correct ?

5 Yes

2 No

Maximum how many triggers can be updated in table ?..

Answer / rohit

depend on the structure of tables

Is This Answer Correct ?

1 Yes

1 No

Maximum how many triggers can be updated in table ?..

Answer / guest

based on the table structure

Is This Answer Correct ?

0 Yes

1 No

Post New Answer