Postgres Plus Advanced Server Oracle Compatibility Developer's Guide : 10.32 DBA_TRIGGERS

Previous PageTable Of ContentsNext Page

Postgres Plus Advanced Server Oracle Compatibility Developer's Guide

 

10.32 DBA_TRIGGERS

The DBA_TRIGGERS view provides information about all triggers in the database.

Name

Type

Description

owner

TEXT

User name of the trigger’s owner.

trigger_name

TEXT

The name of the trigger.

trigger_type

TEXT

The type of the trigger. Possible values are:

      BEFORE ROW

      BEFORE STATEMENT

      AFTER ROW

      AFTER STATEMENT

triggering_event

TEXT

The event that fires the trigger.

table_owner

TEXT

The user name of the owner of the table on which the trigger is defined.

base_object_type

TEXT

Included for compatibility only. Value will always be TABLE.

table_name

TEXT

The name of the table on which the trigger is defined.

referencing_name

TEXT

Included for compatibility only. Value will always be REFERENCING NEW AS NEW OLD AS OLD.

status

TEXT

Status indicates if the trigger is enabled (VALID) or disabled (NOTVALID).

description

TEXT

Included for compatibility only. Value will always be SEE TRIGGER BODY FOR TEXT.

trigger_body

TEXT

The body of the trigger.

action_statement

TEXT

The SQL command that executes when the trigger fires.

Previous PageTable Of ContentsNext Page