select t.TABLE_NAME,d.REFERENCED_NAME,t.TRIGGER_NAME from user_triggers t
left join user_dependencies d on(t.TRIGGER_NAME = d.name)
where t.TABLE_NAME = '自己的表名' and d.REFERENCED_TYPE = 'SEQUENCE'
Oracle中表关联的序列和触发器
最新推荐文章于 2024-07-18 14:34:06 发布
select t.TABLE_NAME,d.REFERENCED_NAME,t.TRIGGER_NAME from user_triggers t
left join user_dependencies d on(t.TRIGGER_NAME = d.name)
where t.TABLE_NAME = '自己的表名' and d.REFERENCED_TYPE = 'SEQUENCE'