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!

How to change the existing constraint for the table.

879159Aug 17 2011 — edited Aug 19 2011
hi my table having the check constraint. but now i want to change the values in that constraint.
is it possible to change the check constraint values. and with out disable or drop my constraint. i dont want to change the constraint name also.
i am expecting answer with out drop or disable the existing constraint
now i will give you my existing constraint and proposed constraint syntax.

my existing constraint Syntax is :
CONSTRAINT CONS_MRANTYPE
CHECK (MRAN_TYPE IN ('SP','JW','SD','SC','OT')

my proposed constraint syntax is :
CONSTRAINT CONS_MRANTYPE
CHECK (MRAN_TYPE IN ('SP','JW','SD','SC','OT','JR')

Thanks
Indra
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 16 2011
Added on Aug 17 2011
12 comments
18,365 views