Re: syntax for not null alter table statement

GIMME wrote:

> 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 <table_name>
ADD CONSTRAINT <constraint_name>
CHECK (column_name NOT NULL);

ALTER TABLE <table_name>
MODIFY (<column_name> NOT NULL);

What's wrong with the published syntax
at http://tahiti.oracle.com and in your
text book?

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)