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: ykhogaly <ykhogaly_at_us.oracle.com>
Date: Wed, 23 Feb 2000 19:07:31 -0700
Message-ID: <8923q4$e2b$1@inet16.us.oracle.com>


Hi,

That is done using "set feedback off" from your sql prompt.

Regards

"The Views expressed here are my own and not necessarily those of Oracle Corporation"

"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 - 20:07:31 CST

Original text of this message

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