Re: SQL*Plus column format not working

Hey-it works! Thanks. Still don't see why the heading should affect the column width when it isn't displayed, but it obviously does.

Calvin Crumrine wrote:

> I'll give it a try but I'm not hopeful. Although I didn't think to include it I
> have headings turned off ('set headings off'). AFAIK the heading therefore
> shouldn't matter. I can (and did yesterday to get this sucker done) use to_char
> in the query & format the resulting column as alphabetic. I don't need computes
> for this one, but I'd like to figure out why the numeric format doesn't work.
>
> Well, like I said, I'll give the heading thing a try. Maybe the heading does
> affect the width even when the heading isn't displayed. Thanks for the
> suggestion.
>
> Aparna wrote:
>
> > hi,
> >
> > to change the width of the column displayed u have to give
> >
> > column <column name> format a<width required>
> >
> > however this does not seem to work for numeric columns... the only option (i
> > have) for numeric columns is to ensure that the column heading too is
> > changed to the desired width
> >
> > column <column name> heading <heading required>
> >
> > so in ur case u will have to give
> >
> > column field_1 format 99 heading NO
> >
> > hope this helps...
> >
> > regards,
> > aparna
> >
> > "A. Bogomol" <bogomol_at_investbank.ru> wrote in message
> > news:9455EAF0C99FD111B85B0060B067688A04E4166F_at_e40.investbank.ru...
> > > Hope, it helps.
> > > col field_1 format 09
> > >
> > > Calvin Crumrine ïèøåò â ñîîáùåíèè <3AE8AAB5.B7401698_at_dced.state.ak.us> ...
> > > >OK-I've obviously forgotten something, can somebody remind me what it
> > > >is? I have a field (Field_1) defined as Number(2). I want the column to
> > > >be only 2 or 3 characters wide.
> > > >
> > > >COL Field_1 FORMAT 99
> > > >SELECT Field_1 FROM Table_1;
> > > > 11
> > > > 22
> > > > 33
> > > >
> > > >What's wrong? Thanks.
> > >
> > >
Received on Fri Apr 27 2001 - 23:37:24 CEST