O'Reilly logo

Oracle APEX 4.2 Reporting by Vishal Pathak

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Understanding download methods

This section is dedicated to understanding various methods to download reports in APEX. The following are the major learning outcomes of this section:

  • Understanding the process to download using APEX format mask.
  • Understanding the process to download using developer-defined, stored procedure.
  • Understanding the process to download using APEX_UTIL.GET_BLOB_FILE_SRC.
  • Understanding the process to download using the p procedure

Before we jump to understanding these methods, we will look at the following region source query of the Slice & Dice region. This query holds the secrets of downloading files using all the ways listed previously. We will talk about the various parts of this query in a short while.

select "OEHR_EMPLOYEE_PROFILES"."EMPLOYEE_ID" ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required