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

What is the parameter mode that can be passed to a procedure?

805


Why do we use coalesce function in oracle?

860


How to convert character types to numeric types?

784


How to generate query output in html format?

762


How to create an oracle database?

781


What is snapshot is too old? Give and example for better understand.

1330


What are the different windows events activated at runtime ?

2621


How to connect ms access to oracle servers?

741


How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?

1709


How to name query output columns in oracle?

927


Explain the use of grant option in imp command.

758


 What are the oracle DML commands possible through an update strategy?

815


How to drop an index?

740


Can a formula column referred to columns in higher group ?

2269


how to join query for one source type is oracle another source type is sql server ?

2213