Re: SQL*Plus column format not working

hi,

[Quoted] 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 - 13:38:54 CEST