SQL> SELECT description, version, action, TO_CHAR(action_time, 'DD-MON-YYYY HH24:MI:SS') AS action_time FROM sys.dba_registry_sqlpatch WHERE description like 'Database PSU%' AND action = 'APPLY';
DESCRIPTION VERSION ACTION ACTION_TIME
---------------------------------------------------------------------------------------------------- -------------------- --------------- -----------------------------
Database PSU 12.1.0.2.181016, Oracle JavaVM Component (OCT2018) 12.1.0.2 APPLY 02-FEB-2019 08:49:29
SQL> SELECT description, version, action, TO_CHAR(action_time, 'DD-MON-YYYY HH24:MI:SS') AS action_time FROM sys.dba_registry_sqlpatch;
DESCRIPTION VERSION ACTION ACTION_TIME
---------------------------------------------------------------------------------------------------- -------------------- --------------- -----------------------------
DATABASE PATCH SET UPDATE 12.1.0.2.181016 12.1.0.2 APPLY 02-FEB-2019 08:40:52
Database PSU 12.1.0.2.181016, Oracle JavaVM Component (OCT2018) 12.1.0.2 APPLY 02-FEB-2019 08:49:29
SQL>
DESCRIPTION VERSION ACTION ACTION_TIME
---------------------------------------------------------------------------------------------------- -------------------- --------------- -----------------------------
Database PSU 12.1.0.2.181016, Oracle JavaVM Component (OCT2018) 12.1.0.2 APPLY 02-FEB-2019 08:49:29
SQL> SELECT description, version, action, TO_CHAR(action_time, 'DD-MON-YYYY HH24:MI:SS') AS action_time FROM sys.dba_registry_sqlpatch;
DESCRIPTION VERSION ACTION ACTION_TIME
---------------------------------------------------------------------------------------------------- -------------------- --------------- -----------------------------
DATABASE PATCH SET UPDATE 12.1.0.2.181016 12.1.0.2 APPLY 02-FEB-2019 08:40:52
Database PSU 12.1.0.2.181016, Oracle JavaVM Component (OCT2018) 12.1.0.2 APPLY 02-FEB-2019 08:49:29
SQL>
No comments:
Post a Comment