Re: Altering a table to allow nulls

From: gazzag <gareth_at_jamms.org>
Date: 21 Sep 2006 03:29:09 -0700
Message-ID: <1158834549.142812.163390@m73g2000cwd.googlegroups.com>

Paps wrote:
> Hi,
>
> I have a table with the following column:
>
>
> COLUMN1 BLOB NOT NULL
>
>
> How can I create a script that will allow me to alter this column to
> allow nulls?
>
>
> Thanks
> Paps

>From the documentation:

alter table demo modify column1 null;

See here:
http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_3001.htm#i2103924

HTH -g Received on Thu Sep 21 2006 - 05:29:09 CDT