Tweet
Key Features
The sections that follow describe key features of Oracle Application Express.
Reporting
With Oracle Application Express, you can quickly generate HTML reports that display the results of SQL queries. You can also download and print reports in HTML, PDF, RTF (compatible with Microsoft Word), and XLS (compatible with Microsoft Excel) formats.
You can declaratively link reports together to provide drill-down reporting and use bind variables to p*** information from session state to a report. Reports support declarative column heading sorting, control breaks, sums, and pagination. Report sorting and pagination can use Partial Page Refresh (PPR) technology to avoid refreshing the entire page. You can also add declarative links to a report to download the report data to CSV or XML formats. Plus, you can customize the report appearance using templates.
"Interactive Reporting" Regions are a further extension of the cl***ic reports that enable dynamic end-users report customization. Users can alter the layout of report data by displaying the columns they are interested in, applying filters, highlighting, and sorting. They can also define breaks, aggregations, include a chart, and their own computations. Users can create multiple variations of the report and save each as a named report. There are also multiple download formats available, including comma-delimited file (CSV) format, Microsoft Excel (XLS) format, Adobe Portable Document Format (PDF), and Microsoft Word Rich Text Format (RTF).
Run Download
Forms
Using wizards, you can easily create forms on tables or on a stored procedure. When creating a form on a table, these wizards provide automatic management of insert, update, and delete as well as lost update detection. Once you create a form, you can rearrange form fields (called form items) using a visual representation, enabling you to quickly achieve the layout you want. Form items offer a variety of display options including text fields, text areas, radio groups, select lists, check boxes, date pickers, and popup list of values.
Run Download
Charting
You can also use wizards to create HTML, SVG, or Flash charts. You can create charts that enable users to drill down from one chart to another chart or report. Charts can also be refreshed using Partial Page Refresh (PPR) technology, avoiding the need to refresh an entire page. You can also configure a chart to refresh at defined intervals. Additionally, you can take advantage of report column templates to add simple HTML bar charts to any report.
Run Download
PDF Printing
As of Application Express 3.0, you can include the ability to export a report region to PDF - essentially, printing a report. A custom link or button can be added to any report region. You can also define Report Queries and Report Layouts under Shared Components. These are custom reports that can be linked anywhere within an application.
Run Download
Web Services
The Application Express Web services engine supports loosely defined types and document style Web services. This makes it possible to support JDeveloper created Web services and Oracle BPEL synchronous Web services. It is also possible to interact with Web services over SSL (HTTPS) and Web services that require basic authentication. Finally, there is also support for manually creating a Web service reference if the Application Express engine cannot correctly parse the WSDL document for a particular service. You supply the SOAP request envelope and the URL endpoint among other information about the Web service.
Spreadsheet Upload
Use the Create Application from Spreadsheet Wizard to quickly upload spreadsheet data directly into the database. You can choose to store the data in a new database table or add it to an existing database table. Once the data is uploaded, you can quickly create an application. This handy wizard enables you to go from spreadsheet
The sections that follow describe key features of Oracle Application Express.
Reporting
With Oracle Application Express, you can quickly generate HTML reports that display the results of SQL queries. You can also download and print reports in HTML, PDF, RTF (compatible with Microsoft Word), and XLS (compatible with Microsoft Excel) formats.
You can declaratively link reports together to provide drill-down reporting and use bind variables to p*** information from session state to a report. Reports support declarative column heading sorting, control breaks, sums, and pagination. Report sorting and pagination can use Partial Page Refresh (PPR) technology to avoid refreshing the entire page. You can also add declarative links to a report to download the report data to CSV or XML formats. Plus, you can customize the report appearance using templates.
"Interactive Reporting" Regions are a further extension of the cl***ic reports that enable dynamic end-users report customization. Users can alter the layout of report data by displaying the columns they are interested in, applying filters, highlighting, and sorting. They can also define breaks, aggregations, include a chart, and their own computations. Users can create multiple variations of the report and save each as a named report. There are also multiple download formats available, including comma-delimited file (CSV) format, Microsoft Excel (XLS) format, Adobe Portable Document Format (PDF), and Microsoft Word Rich Text Format (RTF).
Run Download
Forms
Using wizards, you can easily create forms on tables or on a stored procedure. When creating a form on a table, these wizards provide automatic management of insert, update, and delete as well as lost update detection. Once you create a form, you can rearrange form fields (called form items) using a visual representation, enabling you to quickly achieve the layout you want. Form items offer a variety of display options including text fields, text areas, radio groups, select lists, check boxes, date pickers, and popup list of values.
Run Download
Charting
You can also use wizards to create HTML, SVG, or Flash charts. You can create charts that enable users to drill down from one chart to another chart or report. Charts can also be refreshed using Partial Page Refresh (PPR) technology, avoiding the need to refresh an entire page. You can also configure a chart to refresh at defined intervals. Additionally, you can take advantage of report column templates to add simple HTML bar charts to any report.
Run Download
PDF Printing
As of Application Express 3.0, you can include the ability to export a report region to PDF - essentially, printing a report. A custom link or button can be added to any report region. You can also define Report Queries and Report Layouts under Shared Components. These are custom reports that can be linked anywhere within an application.
Run Download
Web Services
The Application Express Web services engine supports loosely defined types and document style Web services. This makes it possible to support JDeveloper created Web services and Oracle BPEL synchronous Web services. It is also possible to interact with Web services over SSL (HTTPS) and Web services that require basic authentication. Finally, there is also support for manually creating a Web service reference if the Application Express engine cannot correctly parse the WSDL document for a particular service. You supply the SOAP request envelope and the URL endpoint among other information about the Web service.
Spreadsheet Upload
Use the Create Application from Spreadsheet Wizard to quickly upload spreadsheet data directly into the database. You can choose to store the data in a new database table or add it to an existing database table. Once the data is uploaded, you can quickly create an application. This handy wizard enables you to go from spreadsheet