Home arrow Oracle arrow Page 3 - Adding Computations, Processes, and Validations

Computations - Oracle

Validations, computations, and processes greatly increase the functionality of an HTML DB application. In this three-part series (of which this is the first part), you'll learn about the different types and where to use them. This article is excerpted from chapter 13 of the Oracle HTML DB Handbook, written by Lawrence Linnemeyer and Bradley Brown (McGraw-Hill, 2006; ISBN: 0072257687).

  1. Adding Computations, Processes, and Validations
  2. Creating Validations
  3. Computations
  4. Creating Computations
By: McGraw-Hill/Osborne
Rating: starstarstarstarstar / 4
April 19, 2007

print this article



Computations are bits of logic used to populate the value of an application-level item or a page item. Computations can be defined either at the application level through the shared components of an application or on an individual page. Computations defined at the application level will be executed for every page, but as with almost everything in HTML DB, you can specify a condition that will be evaluated before the computation is executed on each page.

When creating a computation, you select the computation point and the computation type. The available computation points are as follows:

  1. On New Instance (for example, On Login)
  2. Before Header
  3. After Header
  4. Before Regions
  5. After Regions
  6. Before Footer
  7. After Footer
  8. After Submit

Select the computation point that makes the most sense for the implementation of your business logic, the relationship of the item whose value you are calculating, and the other items that you might be using in the calculation. With the exception of the After Submit computation point, all the other points occur in the rendering of the page. The After Submit computation point is used for setting the value of items based on user input received from the page but prior to the execution of the page processes.

>>> More Oracle Articles          >>> More By McGraw-Hill/Osborne

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: