Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Spacing between columns in SQL*Plus
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
![]() |
![]() |