ORACLE PATCH 版本的查询 PL/SQL
--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;