query to modify the constraint in oracle

Question

I have the below query from oracle query point of view is that I have created a constraint on table BOA_INVOICE as shown below

ALTER TABLE BOA_INVOICE ADD CONSTRAINT CK_INVOICE_SOURCE_SYSTEM CHECK ( SOURCE_SYSTEM IN ('PCE','PDS'));

Now this constraint is added successfully , but later on i want to modify same constraint add two values as shown below

 ALTER TABLE BOA_INVOICE ADD CONSTRAINT CK_INVOICE_SOURCE_SYSTEM CHECK ( SOURCE_SYSTEM IN ('PCE','PDS','PER','AWE'));

Please advise what will be the query to achieve the same

Hi there. Please, if the given answer solves your problem consider in accepting it. Just click on the V icon on the left on the answer. — Jorge Campos
– Jorge Campos, Commented May 26, 2016 at 21:54

Jorge Campos · Accepted Answer · 2016-05-21 14:21:42Z

5

You need to drop the constraint first and then create it again.

 ALTER TABLE BOA_INVOICE  DROP CONSTRAINT CK_INVOICE_SOURCE_SYSTEM;

Then Create it again:

 ALTER TABLE BOA_INVOICE ADD CONSTRAINT 
      CK_INVOICE_SOURCE_SYSTEM CHECK ( SOURCE_SYSTEM IN ('PCE','PDS','PER','AWE'));

answered May 21, 2016 at 14:21

Jorge Campos

23.9k7 gold badges65 silver badges95 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1