Oracle中根据表明获取对应表触发器名称

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

进行表关联查询 进行触发器名称分组

 

posted @ 2017-07-11 16:09  李文平  阅读(658)  评论(0编辑  收藏  举报