column TRIGGERING_EVENT format a20 column TABLE_OWNER format a15 column TABLE_NAME format a20 column status format a10 select owner,trigger_name,TRIGGER_TYPE,TRIGGERING_EVENT,TABLE_OWNER,TABLE_NAME,status from dba_triggers where owner like upper('%&1%') and trigger_name like upper('%&2%') order by owner,TRIGGERING_EVENT,TRIGGER_TYPE,trigger_name;