Oracle表约束及复杂查询(国外英文资料).docVIP

Oracle表约束及复杂查询(国外英文资料) Grant the resource to zy; Grant dba to zy; -- the constraints of the table Non-null constraint: the constraint of a field is not null Drop table t_user; The create table t_user ( T_number int the not null, T_name varchar2 (255). ); The only constraint of 1.2 is the constraint that a certain field can only be a non-repeatable value Alter table t_user add constraint t_number_unique unique (t_number); Insert into t_user values (1001, 3); Insert into t_user values (1002, li 4); Insert into t_user values (1003, wang 5); Check constraint: check that the value of a field meets