I just notice that in Oracle, one cannot really MODIFY
constraints. Instead, should DROP
and ADD
.
For example, the following line:
ALTER TABLE work_order MODIFY CONSTRAINT status_check CHECK (business_object IN ('Open', 'Closed', 'Hold'));
results in:
Error report: SQL Error: ORA-00933: SQL command not properly ended 00933. 00000 - "SQL command not properly ended" *Cause: *Action: