Feature
USER_TRIGGERS describes triggers owned by the current user.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only MySQL mode.
Related views
ALL_TRIGGERS
DBA_TRIGGERS
Fields
| Field | Type | Nullable | Description |
|---|---|---|---|
| TRIGGER_NAME | VARCHAR2(128) | NO | The name of the trigger. |
| TRIGGER_TYPE | VARCHAR2(16) | NO | The type of the trigger. Valid values: |
| TRIGGERING_EVENT | VARCHAR2(246) | NO | The event that activates the trigger. At present, OceanBase Database supports only INSERT, UPDATE, and DELETE events. |
| TABLE_OWNER | VARCHAR2(128) | NO | The owner of the table. This field takes effect when the object on which the trigger is defined is a table. |
| BASE_OBJECT_TYPE | VARCHAR2(18) | NO | The type of the object on which the trigger is defined. At present, OceanBase Database supports only the TABLE type. |
| TABLE_NAME | VARCHAR2(256) | NO | The name of the table. This field takes effect when the object on which the trigger is defined is a table. |
| COLUMN_NAME | VARCHAR2(4000) | NO | The name of the column. This field takes effect only when the object on which the trigger is defined is a nested table; otherwise, the value is NULL. |
| REFERENCING_NAMES | VARCHAR2(422) | NO | The name used for referencing OLD and NEW column values. |
| WHEN_CLAUSE | VARCHAR2(4000) | YES | The trigger condition |
| STATUS | VARCHAR2(8) | NO | Indicates whether the trigger is enabled or disabled. Valid values: |
| DESCRIPTION | VARCHAR2(65536) | NO | The trigger description, including the name, type, and event information. At present, OceanBase Database contains more information than Oracle. |
| ACTION_TYPE | VARCHAR2(11) | NO | The action type. At present, OceanBase Database supports only actions in PL/SQL. |
| TRIGGER_BODY | VARCHAR2(65536) | NO | The statement that is executed when the trigger activates. At present, OceanBase Database contains more information than Oracle. |
| CROSSEDITION | VARCHAR2(7) | NO | The cross-edition information. This field is not supported at present. |
| BEFORE_STATEMENT | VARCHAR2(3) | NO | Indicates whether the composite trigger contains a BEFORE_STATEMENT section. Valid value: YES or NO. |
| BEFORE_ROW | VARCHAR2(3) | NO | Indicates whether the composite trigger contains a BEFORE_ROW section. Valid value: YES or NO. |
| AFTER_ROW | VARCHAR2(3) | NO | Indicates whether the composite trigger contains an AFTER_ROW section. Valid value: YES or NO. |
| AFTER_STATEMENT | VARCHAR2(3) | NO | Indicates whether the composite trigger contains an AFTER_STATEMENT section. Valid value: YES or NO. |
| INSTEAD_OF_ROW | VARCHAR2(3) | NO | Indicates whether the composite trigger contains an INSTEAD_OF_ROW section. Valid value: YES or NO. |
| FIRE_ONCE | VARCHAR2(3) | NO | This field is not supported at present. |
| APPLY_SERVER_ONLY | VARCHAR2(3) | NO | This field is not supported at present. |