1. Categories >> Software >> Databases >> Oracle >> Oracle General
  2. Suggest New Category

Maximum how many triggers can be updated in table ?

Question Posted / ora

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 logical backup in oracle?

574

What is Library Cache in Oracle?

637

How to call a stored function with parameters?

561

Explain temporal data types in oracle

602

What is instant client oracle?

537




How many anonymous blocks can be defined?

577

Whats the benefit of dbms_stats over analyze?

1489

What is system global area (sga) in oracle?

569

How to load a large xml file?

579

How to count duplicated values in a column in oracle?

550

How to use in conditions in oracle?

547

State the difference between a primary key and foreign key?

510

How to run create database statement again?

618

Please explain drop constraint oracle?

623

How to load data from external tables to regular tables?

535