33 lines
601 B
SQL
33 lines
601 B
SQL
set linesize 250
|
|
column name format a15
|
|
column patch_type format a15
|
|
column status format a15
|
|
column description format a65
|
|
column action_time format a20
|
|
|
|
break on name skip page
|
|
|
|
select
|
|
con.name,
|
|
to_char(sqlp.action_time, 'DD/MM/YYYY HH24:MI') action_time_str,
|
|
sqlp.action,
|
|
sqlp.patch_type,
|
|
sqlp.patch_id,
|
|
sqlp.patch_uid,
|
|
sqlp.source_version,
|
|
sqlp.target_version,
|
|
sqlp.status,
|
|
sqlp.description
|
|
from
|
|
cdb_registry_sqlpatch sqlp
|
|
left outer join v$containers con
|
|
on ( sqlp.con_id = con.con_id )
|
|
order by
|
|
con.name,
|
|
action_time,
|
|
patch_type,
|
|
patch_id
|
|
;
|
|
|
|
clear breaks
|