TA的每日心情 | 开心 2023-8-9 11:05 |
---|
|
- SET ECHO OFF
- SET FEEDBACK ON
- SET HEADING ON
- SET LINESIZE 180
- SET PAGESIZE 2000
- SET TIMING OFF
- SET TRIMSPOOL ON
- SET VERIFY OFF
- CLEAR COLUMNS BREAKS COMPUTES
- COLUMN action_time FORMAT a15 HEADING 'TIME'
- COLUMN action FORMAT a15 HEADING 'ACTION'
- COLUMN NAMESPACE FORMAT a15 HEADING 'NAMESPACE'
- COLUMN VERSION FORMAT a15 HEADING 'VERSION'
- COLUMN BUNDLE_SERIES FORMAT a15 HEADING 'BUNDLE_SERIES'
- COLUMN COMMENTS FORMAT a30 HEADING 'COMMENTS'
- select
- TO_CHAR(action_time, 'yyyy/mm/dd') action_time,
- action,
- namespace,
- version,
- -- bundle_series,
- comments
- from dba_registry_history
- /
复制代码
|
|