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: spoof <spoof_at_earthlink.net>
Date: Thu, 24 Feb 2000 09:34:31 -0800
Message-ID: <38B56BA7.63D2F41E@earthlink.net>


I knew that....duh :-))

Frank Hubeny wrote:

> 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 - 11:34:31 CST

Original text of this message

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