Re: How to get plain output (sqlplus)

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

[Quoted] SELECT coluumn_name || ',' || column_name FROM .... One solution

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)