Oracle SQL*Plus: The Definitive Guide, 2nd Edition

Name

REPFOOTER

Synopsis

The REPFOOTER command defines a report footer. Report footers print on the last page of a report, after the last detail line and before the bottom title. See Chapter 7 for more information.

Syntax

REPF[OOTER] [PAGE] [OFF | ON] | option [option . . . ]
option ::=  [COL x |
             S[KIP] x |
             TAB x |
             LE[FT] |
             CE[NTER] |
             R[IGHT] |
             BOLD |
             FOR[MAT] format_spec |
             text |
             variable]

Parameters

REPF[OOTER]

REPFOOTER is the command, which may be abbreviated REPF. Issuing the REPFOOTER command with no parameters causes SQL*Plus to display the current report footer setting.

[PAGE]

Begins a new page before printing the footer.

OFF

Turns the report footer off but does not erase its definition. You can turn it back on with ON.

ON

Turns on printing of report footers.

COL x

Causes any footer text following this parameter to print at the specified column position.

S[KIP] x

May be abbreviated S. Inserts the specified number of line breaks before printing any subsequent footer text.

TAB x

TAB is similar to COL but moves you the specified number of columns relative to the current position. Negative numbers move you backward. TAB has nothing to do with tab characters.

LE[FT]

May be abbreviated LE. Causes subsequent footer text to be printed beginning at the leftmost column of the current footer line.

CE[NTER]

May be abbreviated CE. Causes subsequent footer text to be centered within the current line. The LINESIZE setting controls the line width.

R[IGHT]

May be abbreviated R. Causes subsequent footer text to ...