Difference between revisions of "Compound Trigger"
Jump to navigation
Jump to search
(Created page with "== What is Compound Trigger? == * A compound trigger is actually four different triggers defined as one. * For example, an UPDATE compound trigger has a ''before statement'', ''...") |
|||
Line 28: | Line 28: | ||
</pre> | </pre> | ||
− | [[Category: | + | [[Category:Database_Features]] |
[[Category:Oracle_11g]] | [[Category:Oracle_11g]] |
Latest revision as of 20:06, 14 March 2011
What is Compound Trigger?
- A compound trigger is actually four different triggers defined as one.
- For example, an UPDATE compound trigger has a before statement, before row, after statement, and after row all rolled into one compound trigger. This a single piece of code, so you can pass variables just like any other monolithic PL/SQL code.
Sample
create or replace trigger tr_compound for update of booking_dton on tab compound trigger : before statement is begin : end before statement; before each row is begin : end before each row; after each row is begin : end after each row; after statement is begin : end after statement; end tr_compound;