Reports2017-11-18T12:27:27+00:00

AD Applied Patches R12.2

Description
Categories: Application, DBA, Enginatics

select 
decode(ad_patch.is_patch_applied(&ebs_release &appltop_id &patch_num &lang),'EXPLICIT','APPLIED','NOT_APPLIED','NOT APPLIED')
from dual

Parameter Name SQL text Validation
Patch language
,:language
Patch number
,:patch_number
Number
Appl top id
,:appltop_id
Number
EBS release version
:ebs_version

By continuing to use the site, you agree to the use of cookies. Accept