Download Blitz Report™ for Oracle Database
Run, schedule and develop Blitz Reports in a browser, with the output delivered to Excel.
- Installs into your existing Oracle database and APEX instance
- Reports on any Oracle database and on Oracle Fusion Cloud
- Trial license for 10 users included
Download Blitz Report™ for Oracle Database v2.02026-11-08
Inside Blitz Report for Oracle Database
Run Blitz Reports in the browser
The Reports page lists the reports you can run, with search, categories and your recent reports. Enter restrictive parameter values, click Run, and the output downloads when the run completes. Runs started from the Excel add-in are listed with the web runs.
- Background runs as database scheduler jobs, so the browser stays free
- Run history on the Runs page, with the output, log and parameter values of every run
- Rerun or cancel a run from the Runs page
- Bookmarks: every report, run and schedule has its own address
Formatted Excel output
Every run delivers a formatted Excel workbook, laid out by the selected template with its columns, conditions and pivot tables, or a CSV, TSV or PDF file.
- Online viewer with sheets, sorting and a row filter, before downloading
- Templates select, summarize, sort and pivot the columns, and are shared with other users
- Your own Excel file as the layout, with its formatting and pivot tables
- Output file name built from tokens such as parameter values
- Excel add-ins to run reports directly in Excel
Scheduled reports by e-mail
Schedule a report with a preset or a calendar expression and have the output e-mailed to its recipients, through the mail server your administrator configured. A schedule keeps its parameter values and its own recipients.
- Every scheduled run in the run history, with its output and log
- Calendar syntax with examples for any interval
- Server copy of the output in a database directory when needed
- No empty e-mails: a run without data sends no output
Report development with SQL only
On the Setup page a report is a SQL query plus parameters, lists of values and templates. The engine is the same as in Blitz Report for Oracle EBS, so reports move between the editions as XML files. Below the SQL editor, every bind, lexical and n=n anchor of the SQL is listed, and a click adds its parameter.
- Validate parses the SQL with the report engine before saving
- Version history of every SQL change
- Assignments decide who can run each report
- Mass change replaces a text in the SQL and lists of values of many reports at once
- Export and import of reports between instances
Installation in your APEX workspace
Import the application in the App Builder, whose supporting objects create the database objects, or run the command-line installer as a DBA. Both methods run the same installation, upgrade and deinstallation scripts from the zip, and give the same result.
- Validations check the database before anything is installed
- Privilege check: a script the DBA runs before installing or upgrading
- Command line: pre-flight checks, a log of every step, resume after a failed run
- Support bundle of a command-line run to send with a question
- Upgrades from the classic application 131 with their own guide
System requirements for Blitz Report for Oracle Database
Blitz Report runs inside the Oracle database and the APEX instance you already operate: no application server, operating-system service or client software is added. The requirements are limited to the database, the APEX instance, the machine the installation is started from, and the users’ browsers.
- Oracle Database 19c or higher, character set AL32UTF8, UTF8 or WE8MSWIN1252, with Oracle Text.
- Oracle APEX 22.2.3 or higher, served through Oracle REST Data Services (ORDS).
- Multitenant databases: install into the pluggable database that hosts APEX.
- Oracle JVM recommended, for PDF output and the Oracle Fusion integration.
- Installation by a workspace administrator (App Builder) or a DBA (command line).
- Users need a current browser: Google Chrome or Microsoft Edge.
