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!

Is there possible to add more than one constraint for a column ?

Augustine VinishFeb 24 2010 — edited Feb 24 2010

Dear Team ,

Is there any possible to add more than one constraint for a column ?
I add one unique for a column ,but I am trying to add not null for the same coloumn .
Its throws Error

ERROR at line 1:
ORA-01430: column being added already exists in table

Thanks
Augustine

This post has been answered by Arun Kumar Gupta on Feb 24 2010

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 24 2010

Added on Feb 24 2010

6 comments

1,254 views