Re: syntax for not null alter table statement

"GIMME" <gimme_this_gimme_that_at_yahoo.com> a écrit dans le message de news:3f12b4fb.0411041907.468438ae_at_posting.google.com...
> I'm not having luck with
>
> alter table add constraint vvv_nn not null (column) ;
>
> Is it possible to add a not null constraint and if so what is the syntax?
>
> thanks

alter table mytable modify (mycol constraint myconstraint not null); alter table mytable add constraint myconstraint check (mycol is not null);

-- 
Regards
Michel Cadot