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: Row Format with SQL*Plus

Re: Row Format with SQL*Plus

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Mon, 10 May 1999 10:46:21 GMT
Message-ID: <373cb8e2.46509927@192.86.155.100>


A copy of this was sent to "stephane buisson" <stephane_buisson_at_yoni.fr> (if that email address didn't require changing) On Mon, 10 May 1999 11:47:09 +0100, you wrote:

>I try to export the result of a query in an spool file, but SQL*PLUS inserts
>blank spaces after each rows (due to the value of LINESIZE I guess). Is it
>possible not to have these blanks?
>
>Thank you!
>

SQL> set trimspool on

will trim trailing blanks from spool files.

See http://www.oracle.com/ideveloper/ for my column 'Digging-in to Oracle8i'...  

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Service Industries
Reston, VA USA

--
Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Mon May 10 1999 - 05:46:21 CDT

Original text of this message

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