Oracle Designer Model,
Release 6i
Element Type Definition
| Element Type Name | DATABASE_TRIGGER |
| Short Name | TRG |
| View Name | CI_DATABASE_TRIGGERS |
| Description | The definition of a database trigger |
| The capability to handle database triggers on views as well as on | |
| tables was new in Oracle8. | |
| Sub-type of | SECONDARY_ACCESS_ELEMENT |
| Versioning: | Belongs to: TABLE_DEFINITION versionable object VIEW_DEFINITION versionable object |
| Rules: |
API Spec Uniqueness Criteria Deletion Rules |
| Descriptor: |
TABLE_DEFINITION_REFERENCE VIEW_DEFINITION_REFERENCE NAME |
| Used by: |
Oracle Designer |
| Underlying table: | SDD_TRG |
| Changes: | Summary of changes to DATABASE_TRIGGER in Release 6i |
| Reference Properties | ||||
|---|---|---|---|---|
| Name | Opt ? | Notes | Relationship | In Arc |
| TABLE_DEFINITION_REFERENCE | N |
Prompt: Table
Transferable only if null |
Must be initiated by one and only one TABLE_DEFINITION | 62 |
| VIEW_DEFINITION_REFERENCE | N |
Prompt: View
Transferable only if null |
Must be initiated by one and only one VIEW_DEFINITION | 62 |
| PLSQL_MODULE_REFERENCE | N |
Prompt: PL/SQL Definition
System maintained: API provides a value only if left null by the user |
Must be logically defined in one and only one PLSQL_MODULE | |
| Properties | |||||
|---|---|---|---|---|---|
| Name | Datatype | Opt ? | Notes | Domain | Default Value |
| COMPLETE_FLAG | VARCHAR2(1) | N | Indicates whether the definition of the database trigger is complete and ready to be used by the generators
Prompt: Complete ? Uppercase | YESNO | Y |
| DATABASE_TRIGGER_FOR | VARCHAR2(3) | N | Arc 62 discriminator. Indicates whether the database trigger is on a table or a view
Not displayed Uppercase System maintained Not updatable by user | DATABASE_TRIGGER_FOR | |
| ENABLED_FLAG | VARCHAR2(1) | N | Specifies whether trigger is to be enabled/disabled when created.
Prompt: Enabled ? Uppercase | YESNO | Y |
| EXECUTE_TIME | VARCHAR2(10) | N | Relative time when trigger should be executed.
Prompt: Time Uppercase | RELATIVE_TIME | BEFORE |
| FIRE_WHEN_PROPAGATED_FLAG | VARCHAR2(1) | N | Indicates whether trigger is to fire when data has been propagated, eg in a multi-master replication environment
Prompt: Fire When Propagated ? Uppercase | YESNO | N |
| NAME | VARCHAR2(30) | N | The trigger name.
Prompt: Name Uppercase | ||
| NEW_ALIAS | VARCHAR2(40) | Y | Alias for keyword NEW.
Prompt: New Alias | ||
| OLD_ALIAS | VARCHAR2(40) | Y | Alias for keyword OLD
Prompt: Old Alias | ||
| PURPOSE | VARCHAR2(70) | N | The purpose of the trigger.
Prompt: Purpose | ||
| TRIGGER_LEVEL | VARCHAR2(20) | N | Specifies whether the trigger is fired at the row or statement level.
Prompt: Level Uppercase | TRIGGER_LEVEL | ROW |
| TRIGGER_ON_DELETE | VARCHAR2(1) | N | Flag to indicate that trigger is fired on delete operation.
Prompt: Delete ? Uppercase | YESNO | Y |
| TRIGGER_ON_INSERT | VARCHAR2(1) | N | Flag to indicate that trigger is fired on insert operation.
Prompt: Insert ? Uppercase | YESNO | Y |
| TRIGGER_ON_UPDATE | VARCHAR2(1) | N | Flag to indicate that trigger is fired on update operation.
Prompt: Update ? Uppercase | YESNO | Y |
| PARENT_IVID | NUMBER(38, 0) | Y | Internal use only. Exists on "secondary" element types from a versioning viewpoint. Contains the IVID of the primary element type (not necessarily a PAC) forming the basis of the "versionable object" to which this element type belongs
Not displayed System maintained Updatable only if null Defined on SAC supertype | ||
| PAC_REFERENCE | NUMBER(38, 0) | Y | Internal use only. Exists on "secondary" element types from a structural viewpoint. Contains the IRID of the PAC forming the basis of the "logical object" to which this element type belongs
Not displayed System maintained Not updatable by user Defined on SAC supertype | ||
| Multi-line Text | ||
|---|---|---|
| Name | Text Type | Prompt |
| DESCRIPTION | CDIDSC | Description |
| HELP | CDHELP | User/Help Text |
| NOTES | CDINOT | Notes |
| WHEN | CDIWHN | Trigger When Condition |
| Other Properties |
|---|
| DATABASE_TRIGGER has the 20 user definable properties (USER_DEFINED_PROPERTY_0, _1, _2, _3 etc) for User Extensibility |
The following 'standard' properties are also inherited by all element types:
|
Other element types that reference DATABASE_TRIGGER:
Note: