SQLPlus Repfooter

REPFOOTER Command Syntax:

REPFOOTER [PAGE] [printspec [text|variable] …] | [ON|OFF]

REPFOOTER Command Example:

REPFOOTER PAGE CENTER ‘END SALES LISTING REPORT’
TTITLE RIGHT ‘Page: ‘ FORMAT 999 SQL.PNO
SELECT CUSTOMER, SALE_SUM
FROM SALES_VIEW
WHERE SALE_SUM > 5000;

CUSTOMER SALE_SUM
————————- ———-
Customer_1 5100
Customer_2 6200
Customer_3 7000
Customer_4 12000

———-
sum 30300

Page: 2
END SALES LISTING REPORT

4 rows selected.