Oracle SQL Plus Pocket Reference, 2nd Edition

Name

COMPUTE

Synopsis

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}...]

The COMPUTE command 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. COMPUTE is a complex command and, to get results, must be used in conjunction with the BREAK command. For example:

BREAK ON project_id
COMPUTE SUM LABEL "Totals" OF hours_logged -
   ON project_id

BREAK ON project_id ON employee_id
COMPUTE SUM OF hours_logged -
   ON project_id, employee_id

Issuing COMPUTE with no parameters causes SQL*Plus to list all currently defined computations.

Parameters

AVG

Computes the average of all non-null values for a numeric column.

COU[NT]

Computes the total number of non-null values for a column.

MAX[IMUM]

Computes the maximum value returned for a column. Applies to columns of type NUMBER, CHAR, VARCHAR2, NCHAR, and NVARCHAR2.

MIN[IMUM]

Computes the minimum value returned for a column. Applies to columns of type NUMBER, CHAR, VARCHAR2, NCHAR, and NVARCHAR2.

NUM[BER]

Performs a function similar to COUNT but computes the number of all values, including nulls.

STD

Computes the standard deviation of all non-null values for a numeric column.

SUM

Computes the sum of all non-null values for a numeric column.

VAR[IANCE]

Computes ...