Re: Formatting SQL*Plus output..

From: Kapil Madan <kapil.madan_at_in.bosch.com>
Date: 12 Mar 1999 06:42:25 GMT
Message-ID: <01be6c53$7c7ced80$140394ad@qcs20.ban.india.bosch.com>

You can have something like this

select
ltrim(rtrim(field1))||','||ltrim(rtrim(field2))||','||ltrim(rtrim(field3)) from table;

Hope this helps.

Kapil

cn_at_127.0.0.1 wrote in article <7c9c7s$e5d$1_at_clarknet.clark.net>...
> I am trying to create comma-seperated output from SQL*plus. It appears
> that all SQL*plus output must be "fixed width." Does anyone know how to
> create comma seperated columns via SQL*Plus without all of the whitespace
> between columns?
>
> --
> Craig Nelson - cn_at_clark.net
> http://www.clark.net/pub/cn
>
Received on Fri Mar 12 1999 - 00:42:25 CST