Re: formating output

From: Adrian Billington <billiauk_at_yahoo.co.uk>
Date: 21 Feb 2002 00:32:26 -0800
Message-ID: <dee17a9f.0202210032.2af11372@posting.google.com>

All your SQL*Plus settings are correct, though you can remove the recsep. You just need to concatenate the columns with commas and each other to get .csv output:-

SELECT column_a||','||column_b||','||column_c||','||etc FROM tab;

recsep won't do it because you want one stream for each record. Recsep will not remove the whitespace between columns in SQL*Plus output.

Regards

Adrian Received on Thu Feb 21 2002 - 02:32:26 CST