SELECT status, source_schema, target_schema, message,
to_char(st_time, 'mon yyyy: hh:mi:ss'),
to_char(en_time, 'mon yyyy: hh:mi:ss')
FROM dbms_upg_status$
WHERE sequence# = (SELECT max(sequence#) FROM dbms_upg_status$)
SELECT STATUS
, SOURCE_SCHEMA
, TARGET_SCHEMA
, MESSAGE
,
TO_CHAR(ST_TIME
, 'MON YYYY: HH:MI:SS')
,
TO_CHAR(EN_TIME
, 'MON YYYY: HH:MI:SS')
FROM DBMS_UPG_STATUS$
WHERE SEQUENCE# = (SELECT MAX(SEQUENCE#)
FROM DBMS_UPG_STATUS$)
|
|
|