Re: Is patch applied

Posted by big on Nov 16, 2022; 10:20am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Is-patch-applied-tp11216p11234.html

Hi,
Here they are:
select ad_patch.is_patch_applied('R12',-1,30628681) from dual;
--------------------
EXPLICIT

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
ad_bugs a,
ad_patch_run_bugs b,
ad_patch_runs c,
ad_patch_drivers d ,
ad_applied_patches e
WHERE
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
a.bug_number in  ('30628681')
ORDER BY 1 DESC;
BUG_APPLIED                          
--------------------------------------
30628681   30628681   08-NOV-22   Y
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%'
  and e.patch_name='30628681';
Patch_NO       Patch
---------------------------------------
30628681        R12.AD.C.DELTA.12

It is actually applied.
Thanks and regards.