@@ -14,85 +14,54 @@ The "Database PL/SQL Language Reference" (11.2) [groups triggers](https://docs.o
1414* System Trigger
1515
1616[ Simple DML Triggers] ( https://docs.oracle.com/cd/E11882_01/appdev.112/e25519/create_trigger.htm#BABBJHHG ) :
17- * before delete
18- * before insert
19- * before update
20- * after delete
21- * after insert
22- * after update
17+
18+ Before | After
19+ --------|-------------
20+ Delete | Delete
21+ Insert | Insert
22+ Update | Update
2323
2424[ Compound DML Triggers] ( https://docs.oracle.com/cd/E11882_01/appdev.112/e25519/create_trigger.htm#BABDFIFA ) :
25- * before delete statement
26- * before insert statement
27- * before update statement
28- * before each row deleted
29- * before each row inserted
30- * before each row updated
31- * instead of each row deleted
32- * instead of each row inserted
33- * instead of each row updated
34- * after each row deleted
35- * after each row inserted
36- * after each row updated
37- * after delete statement
38- * after insert statement
39- * after update statement
25+
26+ Before | Instead of | After
27+ -------------------|-------------------|-------------------
28+ Each Row Deleted | Each Row Deleted | Each Row Deleted
29+ Each Row Inserted | Each Row Inserted | Each Row Inserted
30+ Each Row Updated | Each Row Updated | Each Row Updated
31+ Delete Statement | | Delete Statement
32+ Insert Statement | | Insert Statement
33+ Update Statement | | Update Statement
4034
4135[ Instead of DML Triggers] ( https://docs.oracle.com/cd/E11882_01/appdev.112/e25519/create_trigger.htm#CIHEIGBE ) :
4236* instead of delete
4337* instead of insert
4438* instead of update
4539
4640[ System Triggers] ( https://docs.oracle.com/cd/E11882_01/appdev.112/e25519/create_trigger.htm#BABHEFGE ) :
47- * before alter statement
48- * before analyze statement
49- * before associate statistics statement
50- * before audit statement
51- * before comment statement
52- * before create statement
53- * before database shutdown
54- * before disassociate statistics statement
55- * before drop statement
56- * before grant statement
57- * before noaudit statement
58- * before rename statement
59- * before revoke statement
60- * before truncate statement
61- * before user logoff
62- * instead of alter statement
63- * instead of analyze statement
64- * instead of associate statistics statement
65- * instead of audit statement
66- * instead of comment statement
67- * instead of create statement
68- * instead of disassociate statistics statement
69- * instead of drop statement
70- * instead of grant statement
71- * instead of noaudit statement
72- * instead of rename statement
73- * instead of revoke statement
74- * instead of truncate statement
75- * after alter statement
76- * after analyze statement
77- * after associate statistics statement
78- * after audit statement
79- * after comment statement
80- * after create statement
81- * after database startup
82- * after db role change
83- * after disassociate statistics statement
84- * after drop statement
85- * after grant statement
86- * after noaudit statement
87- * after rename statement
88- * after revoke statement
89- * after servererror
90- * after truncate statement
91- * after user logon
92- * after user suspend
9341
94- For brevity, an example is provided for only one of these triggers.
42+ Before | Instead of | After
43+ -------------------------|-------------------------|-------------------------
44+ Alter Statement | Alter Statement | Alter Statement
45+ Analyze Statement | Analyze Statement | Analyze Statement
46+ Associate Statistics | Associate Statistics | Associate Statistics
47+ Audit Statement | Audit Statement | Audit Statement
48+ Comment Statement | Comment Statement | Comment Statement
49+ Create Statement | Create Statement | Create Statement
50+ Disassociate Statistics | Disassociate Statistics | Disassociate Statistics
51+ Drop Statement | Drop Statement | Drop Statement
52+ Grant Statement | Grant Statement | Grant Statement
53+ Noaudit Statement | Noaudit Statement | Noaudit Statement
54+ Rename Statement | Rename Statement | Rename Statement
55+ Revoke Statement | Revoke Statement | Revoke Statement
56+ Truncate Statement | Truncate Statement | Truncate Statement
57+ User Logoff | . | User Logon
58+ Database Shutdown | . | Database Startup
59+ . | . | Servererror
60+ . | . | User Suspend
61+ . | . | DB Role Change
9562
63+ For brevity, an example is provided for only one of these triggers.
64+ Db Role Change
9665## Table with Insert Trigger
9766
9867Before a trigger an be created, a table must be created. The table will have a surrogate key, a natural key, and audit data.
0 commit comments