13 APEX_DATA_EXPORT
The APEX_DATA_EXPORT package contains the implementation to export data from Oracle Application Express. Supported filetypes include: PDF, XLSX, HTML, CSV, XML and JSON.
Use the EXPORT function to pass a query context from the APEX_EXEC package and return the t_export type, which includes the contents in a LOB.