Select object_name From user_objects a left join all_triggers b on a.object_Name = b.trigger_name where a.object_type='TRIGGER' and b.table_name = 'XF_VIPBONUSADD' group by object_name
进行表关联查询 进行触发器名称分组