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

Home -> Community -> Usenet -> c.d.o.server -> Lost last space

Lost last space

From: astalavista <nobody_at_nowhere.com>
Date: Thu, 8 Nov 2007 21:13:09 +0100
Message-ID: <47336dcb$0$26664$426a34cc@news.free.fr>


Hi,

I have a table with the last column
with only one space
I try to generate a CSV

set colsep '$'
set linesize 500
=> a lot of space at the end of record

set trimspool on
=> no space at the end of a record

How can I get a CSV
with exactly one space at the end of a record ? (as it is in the table)

Thanks for your help Received on Thu Nov 08 2007 - 14:13:09 CST

Original text of this message

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