Maximum how many triggers can be updated in table ?
- 5 Answers
- 15408 Views
- Accenture, Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How to assign a table row to a record variable?
What is a static data dictionary in oracle?
How does the on-delete-cascade statement work?
What are the tools for Oracle ?
Give the different types of rollback segments.
State and explain about oracle instance?
How to manage transaction isolation level?
Explain oracle’s system global area (sga).
How to define an anonymous block?
How to define an oracle cursor variable?
What are nested tables?
Can sub procedure/function be called recursively?
Explain about the analyze command in oracle?
What is a partition in oracle?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
