Scalable Database Server, HiRDB Version 8 UAP Development Guide

[Contents][Index][Back][Next]

2.8.1 Arithmetic operations on numeric data

Four types of arithmetic operations can be performed on numeric values in specified columns, and the results of such operations can be extracted.

The four types of arithmetic operations are addition, subtraction, multiplication, and division.

Figure 2-33 shows an example of performing arithmetic operations on numeric data. Here, projected revenue figures are calculated on the basis of the unit prices and stock quantities of the FASTBACK model; the product codes and calculation results are extracted in million dollar units.

Figure 2-33 Example of numeric data operations

[Figure]