Add a constraint to a column on an Oracle table so that only positive values are allowed
To add a constraint you need to use add constraint:

alter table SPEND_PLAN_DETAIL_VALUE 
  add constraint check_detailvalue CHECK (SP_DETAIL_VALUE_ID &gt; 0);


Online example