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 redo log?
Difference between inner join vs where ?
What is the quickest way to fetch the data from a table?
How to change user password in oracle?
I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance
How many types of table in Oracle?
How to create a table index in oracle?
What is a subquery?
Why do we need oracle client?
How does oracle handle read consistency?
What are the data types in oracle?
Explain self joins in oracle?
Give the constructs of a package, function or a procedure.
What is oracle instant client?
can u plz provide me oca sql dumps please i need them