Subversion Repositories DevTools

Rev

Rev 5939 | Go to most recent revision | Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
5925 dpurdie 1 
-- UsedByPackageSummary.sql
2 
-- Determine packages that depend on a specified package-version
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
6 
 FROM
7 
       package_dependencies dep,
8 
       packages pkg,
9 
       package_versions pv
10 
 WHERE dep.pv_id = pv.pv_id
11 
   AND pv.pkg_id = pkg.pkg_id
12 
   AND dep.dpv_id = :PV_ID
13 
   GROUP BY pkg.pkg_id, pkg.PKG_NAME
14 
ORDER by UPPER(pkg.PKG_NAME)