Subversion Repositories DevTools

Rev

Rev 5925 | Rev 5946 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 5925 Rev 5939
Line 1... Line 1...
1 
-- UsedByPackageSummary.sql
 1 
-- UsedByPackageSummary.sql
2 
-- Determine packages that depend on a specified package-version
 2 
-- Determine packages that depend on a specified package-version
3 
-- Provide the package id, name and count of package-versions
 3 
-- Provide the package id, name and count of package-versions
4 
SELECT DISTINCT
 - 
 
5 
       pkg.pkg_id, pkg.PKG_NAME, count(pv.pv_id) AS count
 4 
select pkg.pkg_name, pkg.pkg_id, count(ppv.pv_id) AS count
- 
 
 5 
  from PACKAGE_DEPENDENCIES dep,
6 
 FROM
6 
  package_versions pv,
7 
       package_dependencies dep,
 7 
  package_versions ppv,
8 
       packages pkg,
 8 
  packages pkg
9 
       package_versions pv
 9 
  Where dep.DPV_ID = pv.pv_id
10 
 WHERE dep.pv_id = pv.pv_id
 10 
  AND dep.PV_ID = ppv.pv_id
- 
 
 11 
  AND pv.PKG_ID in ( select pkg_id from package_versions where pv_id = :PV_ID )
- 
 
 12 
  AND NVL(pv.v_ext,'LINK') in ( select NVL(v_ext,'LINK') from package_versions where pv_id = :PV_ID )
11 
   AND pv.pkg_id = pkg.pkg_id
 13 
  AND pkg.pkg_id = ppv.pkg_id
12 
   AND dep.dpv_id = :PV_ID
 14 
  AND (pv.pv_id = :PV_ID OR :MATCH = 0)
13 
   GROUP BY pkg.pkg_id, pkg.PKG_NAME
 15 
  GROUP BY pkg.pkg_name, pkg.pkg_id
14 
ORDER by UPPER(pkg.PKG_NAME)
16 
  ORDER BY UPPER(pkg.pkg_name)
- 
 
 17
- 
 
 18