check patch applied or not using oracle command

 check patch applied or not using oracle command

-- 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;