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 -> How to get a variable length ASCII file from SQL*PLUS output

How to get a variable length ASCII file from SQL*PLUS output

From: Bu Yun Fei <yfbu_at_ctlsg.creaf.com>
Date: 1997/10/02
Message-ID: <01bccede$df8c32a0$76365fc6@buyunfei.ctlsg.creaf.com>#1/1

Hi,

I'm currently doing data conversion from Oracle database and I need to output data to a variable length ASCII file, which means at the end of each record inside the file, there shouldn't be any trailing space behind. It seems to me that the output from SQL*PLUS is always fixed length.

Appreciate if anyone could tell me how to convert a fixed length text file to a variable length file by using certain UNIX command.  

Thanks in advance !

Yun Fei
e-mail : yfbu_at_ctlsg.creaf.com Received on Thu Oct 02 1997 - 00:00:00 CDT

Original text of this message

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