SET VERIFY OFF FEED OFF

COL "TRIGGER" FORMAT A40
COL TRIGGER_TYPE FORMAT A16
COL TRIGGERING_EVENT FORMAT A40

SELECT OWNER || '.' || TRIGGER_NAME "TRIGGER", TRIGGERING_EVENT, TRIGGER_TYPE, STATUS
FROM DBA_TRIGGERS
WHERE TABLE_OWNER LIKE UPPER('&1.') AND TABLE_NAME LIKE UPPER('&2.')
ORDER BY 1
/

PROMPT

COL "TRIGGER" CLEAR
COL TRIGGER_TYPE CLEAR
COL TRIGGERING_EVENT CLEAR

SET VERIFY ON FEED 6