当前位置： 移动技术网 > IT编程>数据库>Oracle > Oracle数据库中SP和表之间的关系

Oracle数据库中SP和表之间的关系

2018年12月10日  | 移动技术网IT编程  | 我要评论

oracle中sp和表之间的关系

sp-table

select t1.owner as powner,t1.name as pname

,case when t1.referenced_owner in ('sapcrdb','sapirdb') then t1.referenced_owner else t2.owner end as towner

,t1.referenced_name as tname

from all_dependencies t1

inner join all_tables t2

on t1.referenced_name=t2.table_name

where t1.type = 'procedure'

and t1.owner in ('sapcrdb','sapirdb')

and case when t1.referenced_owner in ('sapcrdb','sapirdb') then t1.referenced_owner else t2.owner end = t2.owner

and t1.referenced_type in ('table','view','synonym')

and t1.name='sap_ag_atc'

and t2.temporary='n'

sp-sp

select t1.owner as powner,t1.name as pname

,case when t1.referenced_owner in ('sapcrdb','sapirdb') then t1.referenced_owner else t2.owner end as towner

,t1.referenced_name as tname

from all_dependencies t1

inner join all_objects t2

on t1.referenced_name=t2.object_name

where t1.type = 'procedure'

and t1.owner in ('sapcrdb','sapirdb')

and case when t1.referenced_owner in ('sapcrdb','sapirdb') then t1.referenced_owner else t2.owner end = t2.owner

and t1.referenced_type in ('procedure','synonym')

and t2.object_type='procedure'

and t1.name='sap_ag_etl_01';

您可能感兴趣的文章:

如对本文有疑问， 点击进行留言回复！！

相关文章:

验证码：
最近更新的文章
大家感兴趣的文章
移动技术网