Oracle Patch 版本的查询

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;

 

本文来自CSDN博客,转载请标明出处:http://blog.csdn.net/long_li/archive/2005/08/04/445602.aspx

posted @ 2010-12-05 22:17  郭振斌  阅读(2045)  评论(0编辑  收藏  举报