Re: formating output

An ugly answer, but you can do:

select col1 || ',' || col2 || ',' || col3 || ',' from tab;

Also use 'set trimspool' if you are spooling the results to a file and don't want all the trailing spaces.

Tom

ed zappulla wrote:

> anyone know how to eliminate the lining up of columns from sqlplus?
> 8.1.6. i want a csv output and i get a lot of xtra white space before
> and after the commas set tab off;
> set trim on;
> set linesize 9999;
> set colsep ',';
> set newpage none;
> set heading off;
> set wrap off;
> set feedback off;
> set pagesize 0;select * from tab;
Received on Wed Feb 20 2002 - 23:03:02 CST