Re: Quick SQL Plus spool file question

From: Foo <not_at_telling.com>
Date: Wed, 23 Feb 2000 23:49:16 -0500
Message-ID: <sb9e91v3r2a146@corp.supernews.com>

Try this:

From SQL*Plus

SQL> select * from dept;

DEPTNO DNAME LOC
--------- -------------- -------------

       10 ACCOUNTING     NEW YORK
       20 RESEARCH       DALLAS
       30 SALES          CHICAGO
       40 OPERATIONS     BOSTON

SQL> set heading off;

SQL> set feedback off;
SQL> select * from dept;

       10 ACCOUNTING     NEW YORK
       20 RESEARCH       DALLAS
       30 SALES          CHICAGO
       40 OPERATIONS     BOSTON

SQL>

Takes care of the lines...

"spoof" <spoof_at_earthlink.net> wrote in message news:38B48522.269FA013_at_earthlink.net...
> Running Oracle 8.0.5 on Solaris 2.7
> Is there a way to eliminate the ending three lines of a sqlplus spool
> file?
>
> Example results:
>
> blahblahahaahsflsdjfs
> thelkjklsejfoei;le
> thelajlkjterljrt;ew
>
> 3 rows selected.
>
> Is there a way to eliminated the two blank lines followed by the showing
> of the number of rows selected within the query?
>
> TIA
>
>
>
>
Received on Wed Feb 23 2000 - 22:49:16 CST