Maximum how many triggers can be updated in table ?
Answers were Sorted based on User's Feedback
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 |
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 |
How to open and close an explicit cursor in oracle?
select * from emp what happened internally when we write this query in the sql prompt?
What a SELECT FOR UPDATE cursor represent.?
Whether Oracle satisfy more codd rules or db2 satisfy more codd rules? How meny of each can satisfy ? Please answer me. Advance thanks
What is Database Trigger ?
Explain what are the type of synonyms?
What is a server parameter file in oracle?
sql command 2 know current database
How data locks are respected in oracle?
Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.
What is a nvl function?
What are the different types of database objects?