Re: Changing the format of a Number column in an Oracle 8i Db

From: fumi <fumi_at_tpts5.seed.net.tw>
Date: Thu, 10 May 2001 16:20:43 +0800
Message-ID: <9dedqg$jva$1@news.seed.net.tw>

"Kelvin Jones" <kelvin_at_itxmarket.com> ¼¶¼g©ó¶l¥ó news:9d8ufm$stm$1_at_reader1.fr.uu.net...
> Hi,
>
> I'm trying to modify a NUMBER column in a table from NUMBER(10,2) to
> NUMBER(10,6), changing from a number with 2 decimal places to a number with
> 6 decimal places.
>
> When I try this change I get the error msg:
> ORA-01440: column to be modified must be empty to decrease precision or
> scale
>
> ..however I'm not decreasing the precision. Maybe this is a common error,
> but I would be extremely grateful if somebody could give me a pointer as to
> how to change it, even if it's a round-about method.
>
> Many thanks,
>
> Kelvin

I guess what you want is to change the column to NUMBER(14, 6). Received on Thu May 10 2001 - 03:20:43 CDT