Oracle EBS DBA常用SQL

程序员文章站 2022-05-14 15:12:34

...

Oracle EBS DBA常用SQL - 安装/补丁检查应用补丁有没有安装:select bug_number,last_update_date from ad_bugs where bug_numbe

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%';