Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> How to get a variable length ASCII file from SQL*PLUS output
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