Oracle EBS DBA常用SQL

Oracle EBS DBA常用SQL - 安装/补丁


检查应用补丁有没有安装:
select bug_number,last_update_date from ad_bugs where bug_number='&bug_num';


检查安装了哪些语言:
select nls_language,language_code,installed_flag from fnd_languages where installed_flag in ('I','B');


检查应用有没有安装:
SELECT SUBSTR (fat.application_name
              ,1
              ,30)
          MODULE
      ,fat.application_id
      ,SUBSTR (fa.application_short_name
              ,1
              ,7)
          SN
      ,DECODE (fpi.status
              ,'I', 'Installed'
              ,'S', 'Shared'
              ,'N', 'NOT Installed'
              ,'UNKNOWN')
          STATUS
FROM   fnd_application_tl fat
      ,fnd_product_installations fpi
      ,fnd_application fa
WHERE      fat.application_id = fpi.application_id
       AND fat.application_id = fa.application_id
       AND fa.application_short_name LIKE '%&short_name%';