DBA Registry SQL Patch

➜ Back to Library
XLSExcel example XMLXML import file

Description

Categories
Enginatics, R12 only
Repository
GitHub
DBA_REGISTRY_SQLPATCH contains information about the SQL patches that have been installed in the database.
A SQL patch is a patch that contains SQL scripts which need to be run after OPatch completes. DBA_REGISTRY_SQLPATCH is updated by the datapatch utility. Each row contains information about an installation attempt (apply or roll back) for a given patch.

SQL 11 lines

select
drs.patch_id,
drs.description,
drs.action,
cast(drs.action_time as date) action_date
from
dba_registry_sqlpatch drs
where
1=1
order by
drs.action_time desc

Parameters 3

ParameterTypeList of values SQL
Applied within x DaysNumber
drs.action_time>=sysdate-:days
Date FromDate
drs.action_time>=:date_from
Date ToDate
drs.action_time<:date_to+1