-- -----------------------------------------------------------------------------------
-- File Name    : patch_registry.sql
-- Author       : DBA Learning Hub
-- Description  : Lists all patches applied.
-- Call Syntax  : @patch_registry
-- Requirements : Access to the DBA views.
-- Last Modified: 15/07/2025
-- -----------------------------------------------------------------------------------

set linesize 150
column status format a10
column action_time format a30

select install_id,
       patch_id,
       patch_uid,
       patch_type,
       action,
       status,
       target_version,
       action_time
from   dba_registry_sqlpatch
order by 1;
