APEX offers many item types and templates to use when designing an application. Sometimes this isn't enough, for example, when you have an existing web application built with mod PL/SQL that you want to reuse.
It's possible by using built-in packages such as HTP or HTF, or by using some native APEX code to create these types of pages directly in PL/SQL.
In this example, we are going to build a report without using any items, but only PL/SQL code.
On an empty page, create a new region:
The PL/SQL Source is the most important part of this region. With this, we will be building up the report. To show how this works, we will first ...