Re: SQL*Plus spooling problem

From: janet <janet-SPAM-BLOCK_at_telesph.com>
Date: 1997/02/11
Message-ID: <330084A2.43B8@telesph.com>#1/1

Greg,

     If I understand correctly:
     you have, say, 150 rows of data.  you select *, spooling to a

file.
you end up with say 300 lines of data output.

     your data is too long for the line, so oracle starts a new line. add up your column sizes and a space between each column to get the row size, then set linesize greater than that.

     example: line is 90 bytes.
     SET LINESIZE 100
     select * from table;

HTH
janet

Greg Grooms wrote:
>
> I'm spooling data from a select statement to a file in SQL*Plus on an old
> Oracle 5 database (not my database!). The problem is with too many rows in
> the data file. The data looks OK, but the select count(*) and the wc on
> the file never match. Why would Oracle split up each row into multiple
> rows in the file?
>
> I have tried:
>
> select a, b, c from table1
> select * from table1
> select a||b||c from table1
>
> None work as I expect...1 line per row of data.
>
> Any ideas?
>
> Thanks
Received on Tue Feb 11 1997 - 00:00:00 CST