REPFOOTER CLPPlus command

The REPFOOTER CLPPlus command prints a report footer at the end of a report.

Invocation

You must run this command from the CLPPlus interface.

Authorization

None

Required connection

None

Command syntax

Read syntax diagramSkip visual syntax diagramREPFOOTER,CENTERLEFTRIGHTtextSKIPPAGEnumber-of-lines

Command parameters

text
Specifies the text displayed at the end of a report.
CENTER
Specifies the display will center justify the report footer. If neither CENTER, LEFT, or RIGHT is specified, center justification is the default behavior.
LEFT
Specifies the display will left justify the text for the report footer.
RIGHT
Specifies the display will right justify the text for the report footer.
SKIP
PAGE
Specifies the report footer is displayed on the next new page.
number-of-lines
Specifies the number of lines to skip.

Example

In the following example, the report footer END SALARY REPORT is displayed with center justification at the end of the report on the next new page.

    SQL> REPFOOTER CENTER 'END SALARY REPORT' SKIP PAGE;

In the following example, the report footer Company Name is displayed, two lines are skipped, then End of Report is displayed all with center justification on the next new page.

    SQL> REPFOOTER CENTER "Company Name" SKIP 2, CENTER "End of Report" SKIP PAGE