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?

· It’s Browser driven.

· Provides rapid application development.

· It’s Wizard driven.

· You can quickly build web applications on the Oracle database for:

o Reporting

o Data entry

· Supported by Oracle 9.0.2.3 or later.

· Only needs Oracle HTTP Server.

Browser HTTP Server Oracle DB & HTML DB

HTML DB allows

You can create forms for:

· adding a record

· adding multiple records at a time

· updating a record

· deleting a record(s)

· viewing a record as read only

It 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.

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 dealt with.

For example there may be several projects that must be completed on time for Company A to be profitable. Missing deadlines for any of the projects will cause Company A 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 text documents, and other managers are using spreadsheets.

By creating a hosted application in Oracle HTML DB, each project lead can easily record and track issues 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.

Reports

Reports can be produced that allow users to filter report output. This allows the end user to set values that will be queried against to produce a report. These reports can be sorted by any heading on that 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.

Data can be imported from a spreadsheet into HTML DB and put into an Oracle database. All that is required is the database tables need to be setup first.

Reports can also be produced as pie charts, line charts, date reports (a calendar with text on specific dates where for example a support issue arose), bar charts and text output.

About the Author:

For more articles like this go to http://www.fish4articles.com

HTML - Do We Need To Learn It?

In this article I am going to answer the question as to whether or not we need to learn HTML. This rather long answer will surprise you, but hopefully by the article's end you will understand why. See, this isn't an easy question to answer and there are m

About HTML fonts

It is very tempting to use fancy looking fonts when designing a web page. After all, the fancier the font the more attractive it will be to visitors and the more likely they will be to stay at your p...

The Three Principles Of HTML Code Optimization

Just like spring cleaning a house, the html code of your web pages should get periodic cleaning as well. Over time, as changes and updates are made to a web page, the code can become littered with unnecessary clutter, slowing down page load times and hurt

5 Steps to Understanding HTML

HTML is a relatively simple language, but that doesn't stop people from having problems with it. Why is that? It's mainly because, while the HTML tags themselves are easy, creating an HTML document that works as intended on a web server requires you to kn

HTML Links In Plain English

HTML links. The heart and soul of web pages. Without links it would be impossible for a visitor to get from one web page to another, meaning that without HTML links, web pages would be pretty worthless.