REPORT_FORMATS

6.230 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(128)`	`NOT NULL`	Name of the database component building the report (for example, `sqltune` for SQL Tuning Advisor)
`REPORT_ID`	`NUMBER`	`NOT NULL`	ID number of the report type
`REPORT_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the report type
`FORMAT_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the report format
`DESCRIPTION`	`VARCHAR2(256)`		Description of the report format
`TYPE`	`VARCHAR2(6)`		Format type: `XSLT` - Reports generated by applying an XSLT style sheet to XML data (for example, HTML reports) `Text` - Reports generated by first applying an XSLT style sheet to convert XML data to HTML, and then converting the HTML to formatted Text using the internal report HTML-to-text translation engine. `Custom` - Custom formats implemented natively by report clients
`XSLT_FILENAME`	`VARCHAR2(500)`		Name of the XSLT used for this format (`XSLT` and `Text` format types only)
`XSLT_DATA`	`XMLTYPE`		XSLT data (`XSLT` and `Text` format types only)
`TEXT_LINESIZE`	`NUMBER`		Maximum line size of the formatted text report (`Text` format types only)