Re: Formatting SQL*Plus output..

From: Mark Gumbs <mgumbs_at_hotmail.com>
Date: Fri, 12 Mar 1999 08:53:07 -0000
Message-ID: <36e8d49f.0@145.227.194.253>

The soultion is suggested by our fellow newsgroup buddies in this thread. Only addition is to set pagesize to a high number (like 1000, depends on how many rows you expect). Set trimspool on (to take out any white spaces after the last column).
And set heading off.

Mark

wrote in message <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 - 02:53:07 CST