Re: Change column size

From: Kresimir Fabijanic <kresimir_at_ozemail.com.au>
Date: Sun, 28 Mar 1999 22:47:41 +1000
Message-ID: <36FE24ED.19AD7057@ozemail.com.au>

Ben

I know that this may sound to easy, but I ususally try this: if alter table modify (col number(10,2)) does not work, I try alter table modify (col number(11,2)) and it works, even with the data in the column.

I did it for number(15) to number (20,5) so I do not see why would you have any problem. Try it on a dummy table.

Hope this helps

Kresimir Fabijanic

Ben F Oliver wrote:

> I have a very large table on which I wish to change a column from number (8) to number(10,2)
> does anyone know of an easy way to accomplish this?

Received on Sun Mar 28 1999 - 06:47:41 CST