Monday, May 29, 2017

Query to get Patch Details

SELECT DISTINCT
  RPAD(a.bug_number,11)
  || RPAD(e.patch_name,11)
  || RPAD(TRUNC(c.end_date),12)
  || RPAD(b.applied_flag, 4)  BUG_APPLIED
FROM
  apps.ad_bugs a,
  apps.ad_patch_run_bugs b,
  apps.ad_patch_runs c,
  apps.ad_patch_drivers d ,
  apps.ad_applied_patches e
WHERE 1=1
AND a.bug_id = b.bug_id
AND b.patch_run_id = c.patch_run_id
AND c.patch_driver_id = d.patch_driver_id
AND d.applied_patch_id = e.applied_patch_id
AND C.END_DATE > '01-SEP-16';

ORDER BY 1 DESC;

No comments:

Post a Comment

Best Blogger TipsGet Flower Effect