Name

COMPUTE

Synopsis

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, etc. These calculations are performed by SQL*Plus as the report runs. COMPUTE is a complex command, and must be used in conjunction with the BREAK command to get results. See the Section 7.1 in Chapter 7 for help with this command.

Syntax

COMP[UTE] [functions OF column_names ON breaks]
function ::= function [function...]
function ::= {AVG | COU[NT] | MAX[IMUM] | MIN[IMUM] |
               NUM[BER] | STD | SUM | VAR[IANCE]} [LABEL label_text]
column_names ::= column_name [column_name...]
break ::= break [break...]
break ::= group_column_name | ROW | REPORT}...]

You must have the same number of functions, column_names, and breaks.

Parameters

COMP[UTE]

Is the command, which may be abbreviated COMP. Entering COMPUTE with no parameters causes SQL*Plus to list all currently defined computations.

AVG

Computes the average of all non-null values for a column. AVG applies only to columns of type NUMBER.

COU[NT]

Computes the total number of non-null values for a column. COUNT may be used with columns of any datatype and may be abbreviated COU.

MAX[IMUM]

Computes the maximum value returned for a column. MAXIMUM may be abbreviated MAX, and applies to columns of type NUMBER, CHAR, VARCHAR2, NCHAR, and NVARCHAR2.

MIN[IMUM]

Computes the minimum value returned for a column. MINIMUM may be abbreviated MIN, and applies ...

Get Oracle SQL*Plus: The Definitive Guide, 2nd Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.