REPORT_FORMATS

REPORT_FORMATS displays metadata about the different output formats supported for reports. Some reports are generated in XML only, in which case no data will appear in this view. When reports support HTML or Text formats (for example, the SQL Performance Analyzer reports), metadata about the format will appear in this view. XML reports can be translated to another format with the DBMS_REPORT.FORMAT_REPORT procedure.

Column

Datatype

NULL

Description

COMPONENT_ID

NUMBER

NOT NULL

ID number of the database component building the report

COMPONENT_NAME

VARCHAR2(30)

NOT NULL

Name of the database component building the report (for example, sqltune for SQL Tuning Advisor)