I am running Oracle 8.1 and using SQL*Plus. Do you know if there is a way to stop returned data from breaking to the next line? I need one continuous row of data for each record I retrieve. If I use the LINESIZE function, I have to make it large enough so that when I open the spooled file, I do not see a few line breaks for each row of data. Of course, in instances where the file's to large to open, I run multiple queries with a data range (in hopes to make the files small enough to open). I have been searching online for some sort of information. However, I'm wasting time. Is their an easier way to stop the breaking and keep the spooled file size down?
When I spool this data, I have files as small as 1.26MB and as large as 146 MB. I've noted an increase with the increase of the linesize. My primary goal is to put this into an Excel spreadsheet.
For some of these queries, I will get near 20,000 rows returned (I need them all) and for each row I may have about 300 characters or so.
What else can I do?
Last edited by sfoster; 07-27-04 at 11:17.
Reason: needs better title.