A formula column is a user-created column that gets its data from a PL/SQL function or expression, a SQL statement, or a combination of these.
A formula column performs a user-defined computation on the data of one or more column(s), including placeholder columns. For example, :ITEMTOT *.07 is a formula that performs a computation on one column, while :SAL + :COMM performs a computation using two columns in a record. You create formulas in PL/SQL using the PL/SQL Editor.
Note: Formula columns should not be used to set values for parameters.
For a detailed example of building a report that includes formulas, see the
chapter titled "Building a Group Left Formula Report" in the Oracle
Reports Building Reports manual, available on the Oracle
Technology Network Oracle Reports Documentation page (http://www.oracle.com/technology/documentation/reports.html
).
Creating or editing a formula column
Copyright © 1984, 2005, Oracle. All rights reserved.