',2200,10);
VALUES(cons_sequence.nextval,'','Jack@hotmail.com',2200,10)
*
ERROR at line 2:
ORA-...',2200,10);
VALUES(cons_sequence.nextval,NULL,'Jack@hotmail.com',2200,10)
*
ERROR at line 2:
ORA...',1800;
INSERT INTO tb_constraint_1 --ename为''的记录插入成功
SELECT 16,'','John@hotmail.com',1800;
SELECT...1800
16 John@hotmail.com 1800
(2 row(s) affected)
------------------------------------------...2000 10
114 Mark Mark@hotmail.com 3000 20
--删除主表中deptno为的记录
SQL> DELETE FROM tb_dept WHERE deptno