SQL

Patch Applied to the Oracle Database

-- For upto 11g
COLUMN action_time FORMAT A20
COLUMN action FORMAT A20

COLUMN version FORMAT A10
COLUMN comments FORMAT A30
COLUMN bundle_series FORMAT A10

SELECT TO_CHAR(action_time, 'DD-MON-YYYY HH24:MI:SS') AS action_time,
action,
 version, id, comments, bundle_series
FROM   sys.registry$history
ORDER by action_time;

--From 12c onwards
col action_time for a28
col action for a8
col version for a8
col comments for a30
col status for a10
set line 999 pages 999
select patch_id,  version, status, Action,Action_time from dba_registry_sqlpatch order by action_time;