Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Lost last space
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
![]() |
![]() |