Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Spacing between columns in SQL*Plus

Re: Spacing between columns in SQL*Plus

From: Geoff Reader <grr_at_bton.ac.uk>
Date: Fri, 30 Mar 2001 13:52:51 +0100
Message-ID: <3AC481A3.6E1D1969@bton.ac.uk>

wouldn't that be a

set space 0

aka

set spa 0

I think.

Geoff
University of Brighton

"Mike S." wrote:
>
> 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 - 06:52:51 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US