The event the trigger fires on: 1 - before insert
2 - after insert
3 - before update
4 - after update
5 - before delete
6 - after delete
17 - before insert or update
18 - after insert or update
25 - before insert or delete
26 - after insert or delete
27 - before update or delete
28 - after update or delete
113 - before insert or update or delete
114 - after insert or update or delete
8192 - on connect
8193 - on disconnect
8194 - on transaction start
8195 - on transaction commit
8196 - on transaction rollback
For DDL triggers, the trigger type is obtained by bitwise OR above the event phase (0 - BEFORE, 1 AFTER) and all listed types events: 0x0000000000004002 - CREATE TABLE
0x0000000000004004 - ALTER TABLE
0x0000000000004008 - DROP TABLE
0x0000000000004010 - CREATE PROCEDURE
0x0000000000004020 - ALTER PROCEDURE
0x0000000000004040 - DROP PROCEDURE
0x0000000000004080 - CREATE FUNCTION
0x0000000000004100 - ALTER FUNCTION
0x0000000000004200 - DROP FUNCTION
0x0000000000004400 - CREATE TRIGGER
0x0000000000004800 - ALTER TRIGGER
0x0000000000005000 - DROP TRIGGER
0x0000000000014000 - CREATE EXCEPTION
0x0000000000024000 - ALTER EXCEPTION
0x0000000000044000 - DROP EXCEPTION
0x0000000000084000 - CREATE VIEW
0x0000000000104000 - ALTER VIEW
0x0000000000204000 - DROP VIEW
0x0000000000404000 - CREATE DOMAIN
0x0000000000804000 - ALTER DOMAIN
0x0000000001004000 - DROP DOMAIN
0x0000000002004000 - CREATE ROLE
0x0000000004004000 - ALTER ROLE
0x0000000008004000 - DROP ROLE
0x0000000010004000 - CREATE INDEX
0x0000000020004000 - ALTER INDEX
0x0000000040004000 - DROP INDEX
0x0000000080004000 - CREATE SEQUENCE
0x0000000100004000 - ALTER SEQUENCE
0x0000000200004000 - DROP SEQUENCE
0x0000000400004000 - CREATE USER
0x0000000800004000 - ALTER USER
0x0000001000004000 - DROP USER
0x0000002000004000 - CREATE COLLATION
0x0000004000004000 - DROP COLLATION
0x0000008000004000 - ALTER CHARACTER SET
0x0000010000004000 - CREATE PACKAGE
0x0000020000004000 - ALTER PACKAGE
0x0000040000004000 - DROP PACKAGE
0x0000080000004000 - CREATE PACKAGE BODY
0x0000100000004000 - DROP PACKAGE BODY
0x0000200000004000 - CREATE MAPPING
0x0000400000004000 - ALTER MAPPING
0x0000800000004000 - DROP MAPPING
0x7FFFFFFFFFFFDFFE - ANY DDL STATEMENT
For example trigger
BEFORE CREATE PROCEDURE OR CREATE FUNCTION will be of type 0x0000000000004090 ,
AFTER CREATE PROCEDURE OR CREATE FUNCTION - 0x0000000000004091 ,
BEFORE DROP FUNCTION OR DROP EXCEPTION - 0x00000000000044200 ,
AFTER DROP FUNCTION OR DROP EXCEPTION - 0x00000000000044201 ,
BEFORE DROP TRIGGER OR DROP DOMAIN - 0x00000000001005000 ,
AFTER DROP TRIGGER OR DROP DOMAIN - 0x00000000001005001 . |