Maximum how many triggers can be updated in table ?

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


Please Help Members By Posting Answers For Below Questions

How to assign a table row to a record variable?

783


What is a static data dictionary in oracle?

798


How does the on-delete-cascade statement work?

886


What are the tools for Oracle ?

834


Give the different types of rollback segments.

823


State and explain about oracle instance?

774


How to manage transaction isolation level?

782


Explain oracle’s system global area (sga).

890


How to define an anonymous block?

852


How to define an oracle cursor variable?

793


What are nested tables?

886


Can sub procedure/function be called recursively?

780


Explain about the analyze command in oracle?

819


What is a partition in oracle?

803


What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

1882