SELECT TR.trigger_name, 
       COL.column_name, 
       TR.trigger_body 
FROM   user_triggers TR 
       inner join user_tab_columns COL 
               ON COL.table_name = TR.table_name 
WHERE  TR.trigger_name LIKE 'TH_%' 
       AND TR.trigger_name NOT LIKE 'THC%' 
       AND TR.trigger_name NOT LIKE 'THS%' 
       AND Upper(TR.trigger_body) NOT LIKE '%' 
                                           ||Upper(COL.column_name) 
                                           ||'%' 
ORDER  BY trigger_name 

SELECT distinct TR.trigger_name, COL.column_name
  FROM user_triggers TR, user_tab_columns COL, user_source us
 WHERE COL.table_name = TR.table_name
   and TR.trigger_name LIKE 'TH_%'
   AND TR.trigger_name NOT LIKE 'THC%'
   AND TR.trigger_name NOT LIKE 'THS%'
   and us.type like 'TRIGGER'
   and us.name = tr.trigger_name
   AND to_char(Upper(us.text)) NOT LIKE
       '%' || (Upper(COL.column_name)) || '%'
 ORDER BY trigger_name