2008年
-
编辑 删除
一个关于非空约束enable novalidate的测试
SQL> drop table locations_demo;Table dropped.SQL> CREATE TABLE locations_demo 2 ( location_id NUMBER(4) 3 , street_address VARCHAR2(40) 4 , postal_code VARCHAR2(12) 5 , city VARCHAR2(30) 6 , state_province VARCHAR2(25) 7 , country_id CHAR(2) 8 , CONSTRAINT loc_id_pk PRIMARY KEY (location_id));Table created.SQL> insert into locations_demo values (1,'east load','100000','beijing','beijing','86');1 row created.SQL> insert int
