SET lines 500 col comp_name FOR a40 col version FOR a25 col status FOR a10 SELECT comp_name, VERSION_FULL, status FROM dba_registry; COMP_NAME VERSION_FULL STATUS ---------------------------------------- ------------------------------ ---------- Oracle Database Catalog Views 19.21.0.0.0 VALID Oracle Database Packages AND Types 19.21.0.0.0 VALID Oracle REAL Application Clusters 19.21.0.0.0 VALID JServer JAVA Virtual Machine 19.21.0.0.0 VALID Oracle XDK 19.21.0.0.0 VALID Oracle Database JAVA Packages 19.21.0.0.0 VALID OLAP Analytic Workspace 19.21.0.0.0 VALID Oracle XML Database 19.21.0.0.0 VALID Oracle Workspace Manager 19.21.0.0.0 VALID Oracle Text 19.21.0.0.0 VALID Oracle Multimedia 19.21.0.0.0 VALID COMP_NAME VERSION_FULL STATUS ---------------------------------------- ------------------------------ ---------- Spatial 19.21.0.0.0 VALID Oracle OLAP API 19.21.0.0.0 VALID Oracle Label Security 19.21.0.0.0 VALID Oracle Database Vault 19.21.0.0.0 VALID 15 rows selected.
SET lines 1000 col action_time FOR a20 col action FOR a15 col status FOR a15 SELECT TO_CHAR(action_time, 'DD-MON-YYYY HH24:MI:SS') AS action_time, action, status,patch_id ,description FROM dba_registry_sqlpatch ORDER BY action_time;