Interested to Buy Any Domain ? << Click Here >> for more details...
Maximum how many triggers can be updated in table ?
- 5 Answers
- 16521 Views
- Accenture, Cap Gemini, I also Faced
- E-Mail Answers
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 |
What is the difference between "as" and "is" in an oracle stored procedure?
How to delete all rows a table in oracle?
How to resolve the ORA-39133 error in Oracle?
What is Hash Cluster ?
if i am using dml statement in function. then i am writing select statement what was the output
Explain enable novalidate constraint.
What happens if you use a wrong connect identifier?
How can we create the complete backup of data in the oracle.
0 Answers IPEC, Satyam, SunTec,
What is parameterized cursor in oracle?
I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?
how do u know the total no of rows in a table?
How to manage transaction isolation level?
Oracle General 
