Re: Changing a column to not null and vice versa

alter table table_name modify (column1 not null); alter table table_name modify (column1 null);

To go from a null column to a not null column, you obviously need to make sure that none of the columns being update is null.

Alex Ivascu

"Christopher Kings-Lynne" <chriskl at familyhealth dot com dot au> wrote in message news:3c6b34b2$0$16135_at_echo-01.iinet.net.au...
> Hi Oracle Guys,
>
> I'm a PostgreSQL developer and we wish to implement changing the
nullability
> of a column. We are researching all the different syntaxes, standard and
> otherwise, for changing a column to NOT NULL and vice versa.
>
> So, what is the exact syntax in Oracle for make a NULL column NOT NULL and
> vice versa.
>
> I've tried reading the docs, but I'd prefer to see some actual examples.
>
> It would be much appreciated!
>
> Chris
>
>
Received on Wed Feb 13 2002 - 23:04:47 CST