SQL*Plus User's Guide and Reference Release 8.1.6 A75664-01 |
|
Command Reference, 36 of 52
Places and formats a specified report footer at the bottom of each report, or lists the current REPFOOTER definition.
REPF[OOTER] [PAGE] [printspec [text|variable] ...] [ON|OFF]
Refer to the REPHEADER command for additional information on terms and clauses in the REPFOOTER command syntax.
Enter REPFOOTER with no clauses to list the current REPFOOTER definition.
If you do not enter a printspec clause before the text or variables, REPFOOTER left justifies the text or variables.
You can use any number of constants and variables in a printspec. SQL*Plus displays the constants and variables in the order you specify them, positioning and formatting each constant or variable as specified by the printspec clauses that precede it.
To define "END EMPLOYEE LISTING REPORT" as a report footer on a separate page and to center it, enter:
SQL> REPFOOTER PAGE CENTER 'END EMPLOYEE LISTING REPORT' SQL> TTITLE RIGHT 'Page: ' FORMAT 999 SQL.PNO SQL> SELECT ENAME, SAL 2 FROM EMP 3 WHERE SAL > 2000; Page: 1 ENAME SAL ---------- ---------- JONES 2975 BLAKE 2850 CLARK 2450 SCOTT 3000 KING 5000 FORD 3000 Page: 2 END EMPLOYEE LISTING REPORT 6 rows selected.
To suppress the report footer without changing its definition, enter
SQL> REPFOOTER OFF
|
![]() Copyright © 1999 Oracle Corporation. All Rights Reserved. |
|