Oracle Apex - (Sql) Report (RPT)

A report can shown data as:

• mutable columns:
  • When running a master detail form, data is rendered as a report.
  • A tabular form is rendered as a report having updatable columns shown using various form elements.
• immutable columns as a mean to show information. <note tip>An interactive report gives more possibilities</note>

metadata view:

• APEX_APPLICATION_PAGE_RPT
• APEX_APPLICATION_PAGE_RPT_COLS. See Oracle Apex - Report Columns (RPT COLS)