How to get plain output (sqlplus)

[eban]

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 8) 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

[Daniel Morgan]

eban wrote: 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 8) 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

SELECT coluumn_name || ',' || column_name
FROM ....

One solution
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace 'x' with 'u' to respond)

[eban]

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: SELECT coluumn_name || ',' || column_name FROM ....