Interested to Buy Any Domain ? << Click Here >> for more details...
Maximum how many triggers can be updated in table ?
- 5 Answers
- 16669 Views
- Accenture, Cap Gemini, I also Faced
- E-Mail Answers
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 happens to indexes if you drop a table?
Explain an exception and its types?
How to call a stored function in oracle?
How to select some columns from a table in oracle?
What is a subquery?
candidate key is subset of super key but not vice-verse explain
What is columnar storage what is the advantage?
How to define a record variable to store a table row?
How to specify default values in insert statement using oracle?
Explain the difference between replace() and translate() functions in oracle?
How to pass parameters to procedures?
i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)
How remove data files before opening a database?
How to get last row id?
Explain constraining triggers.
