Types of trigger can be used in a table at a time - oracle

How many types of trigger can be used in a table at a time? What are they?

We can use maximum of 12 triggers on a table.
- BEFORE INSERT
- AFTER INSERT
- BEFORE UPDATE
- AFTER UPDATE
- BEFORE DELETE
- AFTER DELETE

You can define a trigger
- for each row
- for each statement
combining the above 2, makes it 12.
What is partitioned table? What are its types and purposes? - oracle
Partitioned table - Partitioning allows decomposing large tables and indexes into smaller manageable units called partitions...
What is the role of Archiver [ARCn]? - oracle
What is the role of Archiver [ARCn]? - ARCn is an oracle background process responsible for copying the entirely filled online redo log file to the archive log...
Difference between bitmap and btree index in oracle
Difference between bitmap and btree index - Btree It is made of branch nodes and leaf nodes. Branch nodes holds prefix key value along with the link to the leaf node. The leaf node in turn...
Post your comment
Discussion Board
How many types of trigger can be used in a table at a time?

Mr.Shuchi Gauri forgot INSTEAD OF type of trigger.
In Oracle a single table can have up to 14 types of triggers -
7 row level triggers
(BEFORE | AFTER |INSTEAD OF / INSERT, UPDATE, DELETE)
and 7 statement level triggers.
Pavel Nersesov 04-18-2012

Related Content

Follow us

▲