Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Quick SQL Plus spool file question

Re: Quick SQL Plus spool file question

From: Frank Hubeny <fhubeny_at_ntsource.com>
Date: Thu, 24 Feb 2000 00:32:52 -0600
Message-ID: <38B4D094.708A10B9@ntsource.com>


You could turn the "feedback" off:

SQL> set feedback on
SQL> select * from dual;

D
-
X

1 row selected.

SQL> set feedback off
SQL> / D
-
X
SQL> Frank Hubeny

spoof wrote:

> 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 Thu Feb 24 2000 - 00:32:52 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US