Oracle EBS-SQL (SYS-11):查询系统已打的PATCH.sql

2022-04-05 02:34:04

select a.patch_name,
         b.DRIVER_FILE_NAME,
         c.language,
         b.creation_date
from apps.ad_applied_patches    a,
        apps.ad_patch_drivers      b,
        apps.ad_patch_driver_langs c
where a.applied_patch_id = b.applied_patch_id
    and b.patch_driver_id = c.patch_driver_id
order by a.patch_name,
          b.driver_file_name