ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 262963BD56E803D2E0636938A8C0DB52 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 Y US DBA Registry SQL Patch 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. Enginatics 1=1 1 10 1=1 drs.action_time>=sysdate-:days Number 365 US Applied within x Days 2 20 1=1 drs.action_time>=:date_from Date sysdate-:$flex$.applied_within_x_days US Date From 3 30 1=1 drs.action_time<:date_to+1 Date US Date To :$flex$.applied_within_x_days Applied within x Days Date From