PL/Sqlplus-extracting data from Table to comma delim file [message #833] |
Thu, 07 March 2002 07:39 |
Johnson
Messages: 5 Registered: February 2002
|
Junior Member |
|
|
Hi,
Thanks for your help in advance. I'll try to keep it short.
I'm trying to extract data from a table into a comma delimited file using Sql/SqlPlus. I've written the sql and spool it to a file. This works ok, where the problem comes in is that I have to set a linesize so long that the file becomes very big. I would like to remove these "extra" spaces at the end of each line. Each line varies in length as is with a delimited file.
Is there a diff. approach I should be taking? I don't have any 3rd party software to work with only Pl/SQL, Sql,Plus.
Thanks
|
|
|
|