Specifies that the value of this column is calculated from values in other columns and constant expressions. If your column definition refers to a column name within a value expression, that named column must already be defined within the same CREATE TABLE statement. See the Value_Expressions HELP topic for information on value expressions. Any column that you refer to in the definition of a computed column cannot be deleted from that table unless you first delete the computed column. SQL does not allow the following for computed columns: o UNIQUE constraints o REFERENCES clauses o PRIMARY KEY constraints o DEFAULT clause o IDENTITY clause o Default value for DATATRIEVE For example, if the FICA_RATE for an employee is 6.10 percent of the employee's starting salary and the group insurance rate is 0.7 percent, you can define FICA_RATE and GROUP_RATE columns like this: SQL> CREATE TABLE payroll_detail cont> (salary_code CHAR(1), cont> starting_salary SMALLINT(2), cont> fica_amt cont> COMPUTED BY (starting_salary * 0.061), cont> group_rate cont> COMPUTED BY (starting_salary * 0.007)); When you use this type of definition, you only have to store values in the salary_code and starting_salary columns. The FICA and group insurance deduction columns are computed automatically when the columns fica_amt or group_rate are selected.