Subversion Repositories DevTools

-- UsedByPackageSummary.sql
-- Determine packages that depend on a specified package-version
-- Provide the package id, name and count of package-versions
SELECT DISTINCT
       pkg.pkg_id, pkg.PKG_NAME, count(pv.pv_id) AS count
 FROM 
       package_dependencies dep,
       packages pkg,
       package_versions pv
 WHERE dep.pv_id = pv.pv_id
   AND pv.pkg_id = pkg.pkg_id
   AND dep.dpv_id = :PV_ID
   GROUP BY pkg.pkg_id, pkg.PKG_NAME
ORDER by UPPER(pkg.PKG_NAME)