zzgzyyz 发表于 2018-9-12 09:36:30

oracle constraint: check

  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);

页: [1]
查看完整版本: oracle constraint: check