How to get plain output (sqlplus)

eban · *nix forums beginner Joined: 26 Mar 2005 Posts: 10

Oops. in one single column of course. Thanks, I was drifting off too much

Armin
In article <1112398124.385980@yasure>,
DA Morgan <damorgan@x.washington.edu> writes:

DA Morgan · *nix forums Guru Joined: 06 Mar 2005 Posts: 1042

eban wrote:

eban · *nix forums beginner Joined: 26 Mar 2005 Posts: 10

Hi

I am trying to write my query results (sqlplus) to a file, such that records are NOT padded to a fixed length, and each row is one line in the file only.
How should I do this? if I spool, I get a report in which every record is
padded to the same column width. Also my longs (oracle Cool

are wrapped, and if I increase linesize,
long, maxdata etc, i get buffer overflows.
How do I do this right ? I prefer not to use other tools than sqlplus/plsql (needs to be called from a shell script)

Thx for tips
Armin

Google