DBA Registry SQL Patch

➜ Back to Library
Description
Categories: Enginatics
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.
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
Parameter NameSQL textValidation
Applied within x Days
drs.action_time>=sysdate-:days
Number
Date From
drs.action_time>=:date_from
Date
Date To
drs.action_time<:date_to+1
Date
Download
Related Blitz Reports
AR Customer Upload AR Customers and Sites AR Customer Relationships Listing MDS TEST AP Supplier Upload AR Customers and Sites GST COPY OF: AP Supplier Upload AP Supplier Upload JL Brazilian Payables Import Bank Collection Documents Report- Not Supported: Reserved For Future Use AJ: AR Customers and Sites
Blitz Report™