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: 'Carriage Return' in spool file

Re: 'Carriage Return' in spool file

From: Mark G <mgumbs_at_nospam.hotmail.com>
Date: Wed, 30 Jun 1999 10:58:39 +0100
Message-ID: <3779e7fd.0@145.227.194.253>


If you put

set trimspool on

either in sql*plus or at the start of your script, this will eliminate the whitespace at the end of the last field for you.

Mark

Tse wrote in message <7lcors$ce3$1_at_nobel2.pacific.net.sg>...
>Hi,
>
>Whenever I do a select and spool the result to a file in sqlplus on the
Unix
>server, the length of each row of data is fixed as the 'linesize'. (All
rows
>of records have a fix length = linesize.)
>
>How do I put a Carriage Return at the end of each line so that there is no
>whitespaces after the last field? Which means that now the size of each
>record will be different from the others depending on the size of each
field
>that makes up the row.
>
>The field delimiter is the double quote(") and the field seperator is a
>comma(,).
>
>Thanks in advance.
>
>Rgds,
>Tse Chong
>(Please send reply to mailto:tcng_at_yas.com.sg )
>
>
Received on Wed Jun 30 1999 - 04:58:39 CDT

Original text of this message

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