Re: SQL*Plus column format not working
From: A. Bogomol <bogomol_at_investbank.ru>
Date: Fri, 27 Apr 2001 09:38:02 +0300
Message-ID: <9455EAF0C99FD111B85B0060B067688A04E4166F_at_e40.investbank.ru>
Date: Fri, 27 Apr 2001 09:38:02 +0300
Message-ID: <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 - 08:38:02 CEST