I tried following code in SQL Plus, but the printer won't print:
SPOOL TEMP
CLEAR COLUMNS
CLEAR BREAKS
CLEAR COMPUTES
BREAK ON dept SKIP page ON REPORT
SET PAGESIZE 21
SET NEWPAGE 0
SET LINESIZE 200
TTITLE CENTER 'A C M E W I D G E T' SKIP 2 -
LEFT 'EMPLOYEE REPORT' RIGHT 'PAGE:' -
FORMAT 999 SQL.PNO SKIP 2
BTITLE CENTER 'COMPANY CONFIDENTIAL'
SELECT dept, div, app
FROM application
where rownum < 3
ORDER BY department;
SPOOL OUT