摘要:
在看Oracle约束时,看到ENABLE NOVALIDATE,意思是对自现在起及以后的数据启用约束,但是不管以前的数据怎样。不过在实验的时候却出了一点小问题:SQL> create table dept as select * from scott.dept where 1=2; Table created SQL> insert into dept select * from scott.dept where deptno=10; 1 row inserted SQL> insert into dept select * from scott.dept where dep 阅读全文