oracle打印信息,Oracle 打印表信息

SQL> exec print_table('select * from v$database');

DBID                          : 485689964

NAME                          : DODO

CREATED                       : 19-jan-2009 15:10:30

RESETLOGS_CHANGE#             : 1

RESETLOGS_TIME                : 19-jan-2009 14:35:24

PRIOR_RESETLOGS_CHANGE#       : 0

PRIOR_RESETLOGS_TIME          :

LOG_MODE                      : ARCHIVELOG

CHECKPOINT_CHANGE#            : 234242

ARCHIVE_CHANGE#               : 125009

CONTROLFILE_TYPE              : CURRENT

CONTROLFILE_CREATED           : 19-jan-2009 15:10:30

CONTROLFILE_SEQUENCE#         : 210

CONTROLFILE_CHANGE#           : 234242

CONTROLFILE_TIME              : 23-feb-2009 10:04:50

OPEN_RESETLOGS                : NOT ALLOWED

VERSION_TIME                  : 19-jan-2009 15:10:30

OPEN_MODE                     : READ WRITE

PROTECTION_MODE               : MAXIMUM PERFORMANCE

PROTECTION_LEVEL              : MAXIMUM PERFORMANCE

REMOTE_ARCHIVE                : ENABLED

ACTIVATION#                   : 485692838

DATABASE_ROLE                 : PRIMARY

ARCHIVELOG_CHANGE#            : 222873

SWITCHOVER_STATUS             : SESSIONS ACTIVE

DATAGUARD_BROKER              : DISABLED

GUARD_STATUS                  : NONE

SUPPLEMENTAL_LOG_DATA_MIN     : NO

SUPPLEMENTAL_LOG_DATA_PK      : NO

SUPPLEMENTAL_LOG_DATA_UI      : NO

FORCE_LOGGING                 : NO

-----------------

PL/SQL procedure successfully completed