Skip to Main Content
Oracle SQL*Plus Pocket Reference
book

Oracle SQL*Plus Pocket Reference

by Jonathan Gennick
April 2000
Intermediate to advanced content levelIntermediate to advanced
94 pages
1h 52m
English
O'Reilly Media, Inc.
Content preview from Oracle SQL*Plus Pocket Reference

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 must be used in conjunction with the BREAK command in order to get results. 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]
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle SQL*Plus Pocket Reference, 3rd Edition

Oracle SQL*Plus Pocket Reference, 3rd Edition

Jonathan Gennick
Expert Oracle Exadata

Expert Oracle Exadata

Kerry Osborne, Randy Johnson, Tanel Pöder

Publisher Resources

ISBN: 1565929411Catalog PageErrata