select patch_drivers.orig_patch_name "Patch Name",
patch_runs.start_date "Patch Applied Date",
patch_runs.patch_top "Patch Top",
patch_drivers.driver_file_name "Driver File Name",
patch_drivers.patch_abstract "Patch Details",
patch_bugs.no_of_bugs "Bugs"
from applsys.ad_patch_runs patch_runs,
(select patch_run_id, count(patch_run_id) no_of_bugs
from applsys.ad_patch_run_bugs
group by patch_run_id) patch_bugs,
applsys.ad_patch_drivers patch_drivers
where patch_runs.patch_run_id = patch_bugs.patch_run_id and
patch_drivers.patch_driver_id = patch_runs.patch_driver_id /*and
patch_runs.start_date > (select created from v$database) - 1*/
order by patch_runs.start_date desc
No comments:
Post a Comment