December 2002
Intermediate to advanced
928 pages
85h 29m
English
COMP[UTE] [(AVG | COU[NT] | MAX[IMUM] | MIN[IMUM] | NUM[BER] |
STD | SUM | VAR[IANCE])... [LABEL label_text] OF column_name...
ON (group_column_name | ROW | REPORT)...]Defines summary calculations needed in a report. You can use COMPUTE in conjunction with BREAK to calculate and print column totals, averages, minimum and maximum values, and so forth. These calculations are performed by SQL*Plus as the report runs.
Issuing COMPUTE with no parameters causes SQL*Plus to list all currently defined computations.