COLUMN_NAME |
DATA_TYPE |
NULLABLE |
DATA_DEFAULT |
COLUMN_ID |
PK |
COMMENTS |
ID |
NUMBER |
No |
null |
1 |
1 |
Primary Key |
TABLE_OR_VIEW_ID_FK |
NUMBER |
No |
null |
2 |
null |
Table on which this trigger fires |
TRIGGER_ON_FLAG |
CHAR(1 BYTE) |
No |
null |
3 |
null |
Flag to show iif the trigger is on a table or a view. If it is a table this should be 'T'. If it is on a view this should be 'V' |
TRIGGER_NAME |
VARCHAR2(4000 BYTE) |
Yes |
null |
4 |
null |
Name of the trigger //OBJECTNAME |
TRIGGER_TIMING |
VARCHAR2(4000 BYTE) |
Yes |
null |
5 |
null |
before, after ,etc. |
TRIGGER_OPERATION |
VARCHAR2(4000 BYTE) |
Yes |
null |
6 |
null |
insert, delete, etc. |
TRIGGER_EVENT |
VARCHAR2(4000 BYTE) |
Yes |
null |
7 |
null |
The actual trigger that gets fired |
NATIVE_SQL |
CLOB |
Yes |
null |
8 |
null |
The full definition |
NATIVE_KEY |
VARCHAR2(4000 BYTE) |
Yes |
null |
9 |
null |
UInique identifer for this object at source |
LANGUAGE |
VARCHAR2(40 BYTE) |
No |
null |
10 |
null |
//PUBLIC |
COMMENTS |
VARCHAR2(4000 BYTE) |
Yes |
null |
11 |
null |
null |
SECURITY_GROUP_ID |
NUMBER |
No |
0 |
12 |
null |
null |
CREATED_ON |
DATE |
No |
sysdate |
13 |
null |
null |
CREATED_BY |
VARCHAR2(255 BYTE) |
Yes |
null |
14 |
null |
null |
LAST_UPDATED_ON |
DATE |
Yes |
null |
15 |
null |
null |
LAST_UPDATED_BY |
VARCHAR2(255 BYTE) |
Yes |
null |
16 |
null |
null |