Name | Type | Nullable | Default value | Comment |
---|---|---|---|---|
TRIGGER_NAME | VARCHAR2(200) | N | ||
TRIGGER_GROUP | VARCHAR2(200) | N | ||
CRON_EXPRESSION | VARCHAR2(120) | N | ||
TIME_ZONE_ID | VARCHAR2(80) | Y |
Constraint Name | Columns |
---|---|
SYS_C009283 | TRIGGER_NAME , TRIGGER_GROUP |
Constraint Name | Columns | Referenced table | Referenced Constraint | On Delete Rule |
---|---|---|---|---|
SYS_C009284 | TRIGGER_NAME , TRIGGER_GROUP | QRTZ_TRIGGERS | SYS_C009271 | NO ACTION |
Option | Settings |
---|---|
Tablespace | USERS |
Index Organized | No |
Generated by Oracle | No |
Clustered | No |
Nested | No |
Temporary | No |
Index Name | Type | Unuqueness | Columns | DDL script |
---|---|---|---|---|
SYS_C009283 | NORMAL | UNIQUE | TRIGGER_NAME , TRIGGER_GROUP | DDL script |