Triggers

March 7th, 2012

Table triggers

COLUMN trigger_name            FORMAT A25                HEADING "Trigger Name"
COLUMN trigger_type            FORMAT A18                HEADING "Type"
COLUMN triggering_event        FORMAT A9                 HEADING "Trig.|Event"
COLUMN referencing_names       FORMAT A65                HEADING "Referencing Names" newline
COLUMN when_clause             FORMAT A65                HEADING "When Clause" newline
COLUMN trigger_body            FORMAT A65                HEADING "Trigger Body" newline

SELECT
    owner || '.' || trigger_name  trigger_name
  , trigger_type
  , triggering_event
  , status
  , referencing_names
  , when_clause
  , trigger_body
FROM
    dba_triggers
WHERE
      table_owner = UPPER('&schema_name')
  AND table_name  = UPPER('&table_name')
ORDER BY
     trigger_name
/


Comments are closed.