Re: Is patch applied

Posted by ErmanArslansOracleBlog on Nov 11, 2022; 1:05pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Is-patch-applied-tp11216p11224.html

Also check it with;

SELECT DISTINCT
  e.patch_name Patch_NO,
  d.patch_abstract Patch,
  e.CREATION_DATE Applied_Date
FROM
  ad_patch_drivers d ,
  ad_applied_patches e
WHERE
  d.applied_patch_id = e.applied_patch_id and d.patch_abstract like '%AD%'
ORDER BY e.CREATION_DATE desc;