Skip to content

Commit d6bb18d

Browse files
committed
Change Trigger Lists to Tables
1 parent f60c503 commit d6bb18d

1 file changed

Lines changed: 37 additions & 68 deletions

File tree

docs/demo/Trigger-Test.md

Lines changed: 37 additions & 68 deletions
Original file line numberDiff line numberDiff line change
@@ -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

9867
Before 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

Comments
 (0)