SQL*Plus spooling problem

From: Greg Grooms <grooms_greg_at_prc.com>
Date: 1997/02/10
Message-ID: <01bc1779$56ebb1e0$bcccbc8c@localhost.stl.prc.com>#1/1

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 Mon Feb 10 1997 - 00:00:00 CST