SQL Query
SQL> col action_time format a30
SQL> select substr(action_time,1,30) action_time,substr(id,1,8) id,substr(action,1,10) action,
substr(version,1,8) version,substr(bundle_series,1,6) bundle,substr(comments,1,20) comments from registry$history;
or
you can also use
SQL> set serverout on
SQL> exec dbms_qopatch.get_sqlpatch_status;
SQL> col action_time format a30
SQL> select substr(action_time,1,30) action_time,substr(id,1,8) id,substr(action,1,10) action,
substr(version,1,8) version,substr(bundle_series,1,6) bundle,substr(comments,1,20) comments from registry$history;
or
you can also use
SQL> set serverout on
SQL> exec dbms_qopatch.get_sqlpatch_status;
No comments:
Post a Comment