Re: Spacing between columns in SQL*Plus

From: Mike S. <no email>
Date: Fri, 30 Mar 2001 02:11:13 -0800
Message-ID: <ipm8cto53ap5dki1ebpeuuuf6v8qdq88lu@4ax.com>

On 30 Mar 2001 00:26:46 GMT, bdahms_at_geoprocessing.com wrote:

A column command with "FM" in the format model should do it:

COLUMN somenumber FORMAT FM9,990.00

Mike S.

>Is there a way to format a SQL*Plus report so numeric columns do not
>always follow a space? I've already SET COLSEP '' but that doesn't seem to
>affect numeric fields. I've also played with the column format, and have
>tried converting the numbers to strings.
>
>
>
>
> ----- Posted via NewsOne.Net: Free (anonymous) Usenet News via the Web -----
> http://newsone.net/ -- Free reading and anonymous posting to 60,000+ groups
> NewsOne.Net prohibits users from posting spam. If this or other posts
>made through NewsOne.Net violate posting guidelines, email abuse_at_newsone.net
Received on Fri Mar 30 2001 - 04:11:13 CST