Cannot MODIFY CONSTRAINT in Oracle

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:
Advertisements