Oracle中SP与表之间的关系
来源:互联网 发布:淘宝上的好评能删除吗 编辑:程序博客网 时间:2024/06/09 18:50
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';
- Oracle中SP与表之间的关系
- Android中dp,sp以及px之间的关系
- Android 中px pt sp dp之间的关系
- Android中dp、sp、px、pt之间的换算关系
- px,sp,dp 之间的关系
- PX,DP,SP之间的关系
- Android px,sp,dp,sp 之间的关系
- SP与运营商的关系
- Android中dp、sp与px之间的相互转换
- android中px与sp,dp之间的转换
- UI设计中px、pt、ppi、dpi、dp、sp之间的关系
- UI设计中px、pt、ppi、dpi、dp、sp之间的关系
- Sp与dp之间的区别
- oracle查看表之间的关联关系
- oracle查看表之间的关联关系
- px、pt、ppi、dpi、dp、sp之间的关系
- px、pt、ppi、dpi、dp、sp之间的关系
- Android开发,dp、sp和px之间的关系
- 习题1
- Hyperledger Fabric 核心术语
- redis集群报错:clusterdown the cluster is down
- 1082. Read Number in Chinese (25)
- 一个人的旅行
- Oracle中SP与表之间的关系
- 1041. Be Unique (20)
- 【HNOI2010】弹飞绵羊
- 084 定积分总结及习题
- 集合类
- BZOJ-5091 (概率期望)
- 数据结构实验之串一:KMP简单应用
- 集合之ArrayList总结
- 1053. 住房空置率 (20)