--ORACLE PATCH 版本的查询 PL/SQL

SELECT DD.PATCH_NAME,

       PP.CREATION_DATE,

       PP.DRIVER_FILE_NAME,

       LANG.LANGUAGE

  FROM AD_PATCH_DRIVERS PP,

       AD_APPLIED_PATCHES DD,

       AD_PATCH_DRIVER_LANGS LANG

WHERE PP.APPLIED_PATCH_ID = DD.APPLIED_PATCH_ID

   AND LANG.PATCH_DRIVER_ID = PP.PATCH_DRIVER_ID

ORDER BY PP.CREATION_DATE;