Re: Changing a column to not null and vice versa

ALter Table <tablename> modify Column Not Null

But Be Aware that the table should be empty to do this.

ALter Table <tablename> modify Column Null

HTH On Thu, 14 Feb 2002 11:54:54 +0800, "Christopher Kings-Lynne" <chriskl at familyhealth dot com dot au> wrote:

>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
>

[Additions and Corrections Always Welcome.] Best Regards,
Ganesh R Received on Wed Feb 13 2002 - 23:14:25 CST