Lin Hong's TECH Blog! 刀不磨要生锈,人不学习要落后 - Thinking ahead

Oracle 19c Query the patch Tips

2019-08-23

Oracle 19c Query the patch Tips

Query the patch applied on database 19c.

SYS@orcl> !cat patch_list.sql
set line 300
col action form a12
col version  form a40
col comments form a60
col action_date form a20

select comments, action, to_char(action_time,'DD/MM/RR HH24:MI:SS') action_date, version from registry$history order by action_date;

set line 300
col action form a12
col version  form a40
col description form a60
col action_date form a20
select description, action, to_char(action_time,'DD/MM/RR HH24:MI:SS') action_date, ' ' version from dba_registry_sqlpatch;

SYS@orcl>

Oracle_Patch_list

Have a good work&life! 2019/08 via LinHong


Similar Posts

Comments