REPHEADER CLPPlus command

The REPHEADER CLPPlus command prints a report heading once at the beginning 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 diagramREPHEADER,CENTERLEFTRIGHTtextSKIPPAGEnumber-of-lines

Command parameters

text
Specifies the text displayed for the report header.
CENTER
Specifies the display will center justify the report header. 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 header.
RIGHT
Specifies the display will right justify the text for the report header.
SKIP
PAGE
Specifies the report header is displayed and the report data starts on the next new page.
number-of-lines
Specifies the number of lines to skip.

Example

In the following example, the report header SALARY REPORT is displayed with left justification and the report data starts on the next new page.

    SQL> REPHEADER LEFT 'SALARY REPORT' SKIP PAGE;

In the following example, the report header COMPANY NAME is displayed, two lines are skipped, and then SALARY REPORT is displayed all with center justification. The report data starts on the next new page.

    SQL> REPHEADER CENTER 'COMPANY NAME' SKIP 2, CENTER 'SALARY REPORT' SKIP PAGE;