User Tools

Site Tools


usefulscripts

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
usefulscripts [2020/02/06 13:41] z0hpvkusefulscripts [2025/03/08 22:24] (current) – external edit 127.0.0.1
Line 330: Line 330:
 </code> </code>
  
-====Patching====+====Patching and Registry====
 <code SQL> <code SQL>
 SET LINESIZE 120 SET LINESIZE 120
Line 337: Line 337:
  
 select PATCH_ID, ACTION_TIME, DESCRIPTION from DBA_REGISTRY_SQLPATCH; select PATCH_ID, ACTION_TIME, DESCRIPTION from DBA_REGISTRY_SQLPATCH;
 +</code>
 +
 +<code SQL>
 +SET LINESIZE 120
 +COL COMP_NAME FORMAT A40
 +COL VERSION FORMAT A20
 +
 +select COMP_NAME, VERSION, STATUS from DBA_REGISTRY;
 </code> </code>
  
usefulscripts.1580996504.txt.gz · Last modified: 2025/03/08 22:23 (external edit)