SQL Reports - spool command
Posted on 2001-06-25
Hi there !!!
I am using the reporting feature of SQL. I am giving the following commands for printing my report :
SET LINESIZE 47
TTITLE CENTER "Employee Report"
COLUMN empno FORMAT 9999 HEADING "Empno"
COLUMN ename FORMAT A15 HEADING "Emp. Name"
SELECT empno, ename FROM emp WHERE deptno = 20;
Now when I print the file EMP_REP.LST from DOS prompt or Notepad, the following select command is printed in the beginning of report :
"SQL> SELECT EMPNO, ENAME FROM EMP WHERE DEPTNO = 20"
and the following line is printed at the end of the report :
"51 ROWS SELECTED"
I dont want these lines at the beginning and the end of my output file. So please tell me what should I do to avoid these lines in the output file.