oracle表建好后增加check约束的方法:

alter table table_name add constraint constraint_name check (column_name condition);

eg:

   alter table purchase add constraint purchase_nums_c check (nums between 1 and 30);