oracle 114091023-李秋丹-13章.docVIP

例12-21 insert into scott.person (personid,name,birthday,edulevel,passaway,intro) values (001,苏妲己,NULL,NULL,NULL,狐狸精) 例12-22 Commit; 例12-23 select * from scott.person 例12-24 insert into scott.person (personid,name,birthday,edulevel,passaway,intro) values (002,潘金莲,NULL,NULL,NULL,武大郎之妻) 例12-25 Commit; 例12-26 select * from scott.person 例12-27 update scott.person set name = 001 例12-28 Commit; 例12-29 select * from scott.person 例12-30 alter table scott.person enable novalidate constraint person_personid_pk 例12-31 select constraint_name,table_name,constraint_type, status,deferrable,deferred,validated