Home arrow Oracle arrow Page 6 - Developing Applications on Oracle 10g XE: Generating a Report

Running a report, searching and sorting - Oracle

This tutorial shows you how to create a report based on a table in the Oracle 10g XE database without stepping out of the IDE. It will show you how to manipulate the report and create a UI.

  1. Developing Applications on Oracle 10g XE: Generating a Report
  2. Building an Application
  3. Creating a report from scratch
  4. Adding a Page
  5. Adding a User Interface
  6. Running a report, searching and sorting
By: Jayaram Krishnaswamy
Rating: starstarstarstarstar / 16
July 05, 2006

print this article



At this point we can run the application by clicking on the Run Application icon to see the result of the design we carried out thus far. This opens up the report as shown in the next picture. At the very top is an annotation saying Anonymous User.

In this window we see the top part of this report. The report has been cut into a top half and a bottom half for display in this tutorial. The report title is "Employees." By default it shows 15 rows, but you can change it (10 to 5000). You can also carry out a search on this page.

For example, when the page is searched for "John,"  the result shown in the next screen pops up.  It looked for "John" everywhere and displayed what it found.

The default sorting was EmployeeID (see picture above), but clicking on the LastName column heading sorted the results for this column as shown in the next picture. Review the Last Name column and also observe the little UP arrow alongside the column name.

The screen in the next picture shows the bottom half of the Employees report screen. Here you can scroll the pages to show all the 107 rows, in pages of 15 rows each.

Clicking on the hyperlink SpreadSheet (bottom left) brings up the next screen where you can download  the report to a CSV spreadsheet, as shown in the next screen.

At the bottom-center of the screen shown above, there are several hyperlinks that allow you perform a number of report manipulations. These will not be discussed in this tutorial.


Oracle XE, with its streamlined application building process, makes it very easy  to create applications. This tutorial described the creation of a simple report, but it exposed the immense possibilities for designing and reusing the user interface in a consistent manner across applications. The generated report looks cool, can be sorted, searched, and exported very easily. With no fussy paging problems, and a smooth UI, it is an excellent RAD tool, totally integrated with the backend both for data and security.

>>> More Oracle Articles          >>> More By Jayaram Krishnaswamy

blog comments powered by Disqus
escort Bursa Bursa escort Antalya eskort


- Oracle Java Security Woes Continue
- Oracle's New IaaS Cloud Option: There's a Ca...
- Oracle Acquires Eloqua to Boost Cloud Presen...
- Choosing Innovation: Oracle Survey Insights
- Oracle Fixes Privilege Escalation Bug
- Oracle`s Communications Service Availability...
- Oracle Releases Exalytics, Taleo Plans
- Oracle Releases Communications Network Integ...
- Oracle Releases Communications Data Model 11...
- Oracle Releases PeopleSoft PeopleTools 8.52
- Oracle Integrates Cloudera Apache Distro, My...
- Oracle Releases MySQL 5.5.18
- Oracle Announces NoSQL Database Availability
- Sorting Database Columns With the SELECT Sta...
- Retrieving Table Data with the LIKE Operator

Developer Shed Affiliates


Dev Shed Tutorial Topics: