AD Applied Patches R12.2 Copy link
Description
- Categories
- Enginatics
- Repository
- GitHub
Check if a specific patch is applied in 12.2
SQL 3 lines
select decode(ad_patch.is_patch_applied(:ebs_release, :appltop_id, :patch_num &lang),'EXPLICIT','APPLIED','NOT_APPLIED','NOT APPLIED') applied_check from dual |
Parameters 4
| Parameter | Type | List of values SQL | |
|---|---|---|---|
| EBS release version | Char | ||
| Appl top id | Number | ||
| Patch number | Number | ||
| Patch language | Char |
|