HTML database (HTML DB) uniquely converts an Oracle database into an online development service, which enables anyone with a Web browser to create reporting and data-entry applications quickly without the need for professional programming skills.

What Is Oracle HTML DB? In short, it’s browser driven, wizard driven, and provides rapid application development capabilities. You can quickly and easily build web applications on the Oracle database for reporting and data entry, and its supported by Oracle 9.0.2.3+ – it only needs Oracle HTTP Server.

HTML DB allows you to create forms for adding records, uploading records in bulk, plus the ability to update and delete records if need be. You may also view any record as read only.

HTMLDB allows you to setup triggers that execute when a particular action is committed by the user. For example, if a user clicks the delete button, some code will execute that will remove a product from the Oracle database, or write that record to another table, so that you have an audit trail.

Data is stored centrally and can be accessed by users from various locations. Users can be given privileges, where they can access only their own data. As an example following is a business scenario.

Here is a simple business scenario: Effective project management is the key to completing any project on time and within budget. Within every project there are always multiple issues that need to be tracked, prioritized, and handled; for instance, there may be several projects that must be completed on time for Company X to be profitable. Missing deadlines for any of the projects will cause Company X to lose money. The project leads are tracking issues in several different ways. Some individuals are manually tracking issues in notebooks, others are tracking issues in documents, and other managers are using .xlsx spreadsheets.

By creating a hosted application in Oracle HTML DB, each project lead can easily record and track problems in one central location. Not only will everyone have access to just the data they need, but, having the data stored in one location will make it easier for management to determine if any critical issues are not being addressed.

The solution can produce reports that allow users to filter report output. This allows the end user to set values that will be run against to produce a report. These reports can be sorted by any heading on that same report, and, can also be filtered down again. To produce these reports, a developer needs to set the reports up and add the SQL queries or PL/SQL code to HTML DB. All that’s required is the database tables need to be setup first. Reports can also be produced as pie charts, line graphs, date reports, bar charts and more.