Re: SQL*Plus spooling problem

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

Greg,

        sqlplus is breaking up the line for readability. there is an option to change the displayed line size. I think it's 'set linesize' , so set it to a value larger than you're expecting. This will solve your problem.

-- 
---
Allen Kirby			AT&T ITS Production Services
akirby_at_att.com			Alpharetta, GA.