Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Row Format with SQL*Plus
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