Skip to Main Content

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!

Add Not NULL constraint in the exisitng table that has null values

2754423Nov 20 2014 — edited Nov 21 2014

Hi,

I want to add a not null constraint to and exisitng table, but the table already has some null values in that column.

Emp

Emp_id  Name

1               axada

2              

3               sdkdd

Here the data is already present i.e 2 empid has Null as name. I have to add a not null constraint sot that new values will not null but i also dont want to change the alreadt exisitng data that has NULL value.

This post has been answered by BrunoVroman on Nov 20 2014
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 19 2014
Added on Nov 20 2014
10 comments
2,282 views