Re: Resize Columns

alter table xx modify(n varchar2(100));

You can even make it shorter if you have all NULLs in the column.

Regards,
Karen Abgarian.

In2Home User wrote:

> I'm sure this is an age-old question, but
> can I resize the columns of an Oracle 8.0.5 table
> without having to drop and recreate the table?
>
> Thanks,
>
> Chris
Received on Tue Sep 14 1999 - 13:59:58 CDT