SELECT dd.*FROM dba_dependencies dd
WHERE NAME <> referenced_name
AND referenced_type <>'TABLE'AND dd.referenced_type ='PACKAGE'AND dd.referenced_name LIKE'%CUX%'AND NAME ='CUX_PACKAGE_NAME'
此SQL并未实现递归,若要实现完整递归,请自行尝试。
posted on
2018-01-28 14:41红无酒伤
阅读(1972)
评论(0)
编辑收藏举报