usefulscripts
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
usefulscripts [2020/02/06 13:41] – z0hpvk | usefulscripts [2025/03/08 22:24] (current) – external edit 127.0.0.1 | ||
---|---|---|---|
Line 330: | Line 330: | ||
</ | </ | ||
- | ====Patching==== | + | ====Patching |
<code SQL> | <code SQL> | ||
SET LINESIZE 120 | SET LINESIZE 120 | ||
Line 337: | Line 337: | ||
select PATCH_ID, ACTION_TIME, | select PATCH_ID, ACTION_TIME, | ||
+ | </ | ||
+ | |||
+ | <code SQL> | ||
+ | SET LINESIZE 120 | ||
+ | COL COMP_NAME FORMAT A40 | ||
+ | COL VERSION FORMAT A20 | ||
+ | |||
+ | select COMP_NAME, VERSION, STATUS from DBA_REGISTRY; | ||
</ | </ | ||
usefulscripts.1580996504.txt.gz · Last modified: 2025/03/08 22:23 (external edit)