Skip Headers
Oracle® Database Reference
12c Release 1 (12.1)

E17615-24
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

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)