Hi,

A quick question.

This code works:
create table test ( id number constraint id_nn not null);

This also works:
create table test ( id number);
alter table test modify id not null;

But this one (the 2nd line) gave me error:
create table test ( id number);

SQL> alter table test add constraint id_nn not null (id);
alter table test add constraint id_nn not null (id)
*
ERROR at line 1:
ORA-00904: invalid column name


So what is the correct syntax for that?

TIA.

Guang

_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp

Oracle LazyDBA home page