SQLPlus Repheader

REPHEADER Command Syntax:

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

REPHEADER Command Example:

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

Page: 1

SALES LISTING REPORT

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

———-
sum 30300

4 rows selected.