Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

adding not null constraint to existing table

339470Nov 15 2002 — edited Aug 15 2008
hi, i am trying to add a not null constraint to a column i have already created.
i have this
ALTER TABLE mytable
MODIFY (mynumber NUMBER(8,2) NOT NULL);
but i need to give this constraint a name.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 12 2008
Added on Nov 15 2002
5 comments
152,826 views