Skip to Main Content
Oracle in a Nutshell
book

Oracle in a Nutshell

by Rick Greenwald, David C. Kreines
December 2002
Intermediate to advanced content levelIntermediate to advanced
928 pages
85h 29m
English
O'Reilly Media, Inc.
Content preview from Oracle in a Nutshell

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 the variance of all non-NULL values for a numeric column.

LABEL

Allows you to specify a label for the computed value. If possible, this label will be printed to the left of the computed value.

label_text

Text you want to use as a label when the computed value is printed.

column_name

Name of the column you are summarizing. If it’s a computed column, the expression is the name. If your SELECT statement aliases the column, you must use that alias name here.

group_column_name

Causes SQL*Plus to restart the calculation every time this column changes.

ROW

Causes the computation to be performed once for each row returned by the query.

REPORT

Causes the computation to be performed at the end of the report and to include values from all rows. REPORT is used for grand totals.

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 Internals

Oracle Internals

Donald K. Burleson
Oracle PL/SQL

Oracle PL/SQL

Lewis Cunningham
Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Rick Greenwald, Robert Stackowiak, Jonathan Stern

Publisher Resources

ISBN: 0596003366Errata Page