Re: SQL*Plus column format not working

[Quoted] 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 - 18:57:49 CEST