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);
转载于:https://blog.51cto.com/lihsing/1404436
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);
转载于:https://blog.51cto.com/lihsing/1404436