-- For 12c and 18c
set line 1000
col action form a12
col version form a40
col description form a85
col action_date form a20
select description, action, to_char(action_time,'DD/MM/YYYY HH24:MI:SS') action_date, ' ' version
from dba_registry_sqlpatch
order by action_time desc
fetch first 1 rows only
/
