oracle里的参照完整性有问题吗? 本帖最后由 hky227 于 2012-04-07 10:29:18 编辑 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 -- Create tablecreate table DEPT_TEST( DEPTNO NUMBER(2) not null, DNAME VARCHAR2(14), LOC VARCHAR2(13));alter table DEPT_TEST add constraint PK_DEPT_TEST primary key (DEPTNO); -- Create tablecreate table EMP_TEST( EMPNO VARCHAR2(10), ENAME VARCHAR2(10), SEX VARCHAR2(9), DEPTNO NUMBER(2));alter table EMP_TEST add constraint FK_DEPTNO_TEST foreign key (DEPTNO) references DEPT_TEST (DEPTNO);SQL> select * from dept_test; DEPTNO DNAME LOC------ -------------- -------------SQL> --插入deptno空的时候可以正常插入SQL> insert into EMP_TEST values('e005','kk','f',NULL); 1 row insertedSQL> COMMIT; Commit completeSQL> SELECT * FROM EMP_TEST; EMPNO ENAME SEX DEPTNO---------- ---------- --------- ------e005 kk f SQL> insert into EMP_TEST values('e005','kk','f',10); insert into EMP_TEST values('e005','kk','f',10) ORA-02291: integrity constraint (SCOTT_TEST.FK_DEPTNO_TEST) violated - parent key not foundSQL> COMMIT; Commit completeSQL> SELECT * FROM EMP_TEST; EMPNO ENAME SEX DEPTNO---------- ---------- --------- ------e005 kk f 无法将NULL插入("SYSTEM"."EMP"."DE_ID") 怎配置oem使之用起来??? 数据库菜鸟求教 sql 语句 oracle海量数据如何导出成多个文本文件? TNS: 监听程序无法启动专用服务器进程。请专家给出具体解决方案,先谢谢! 我的服务项里面的OracleServiceoradb 不见了 ORACLE数据库12560错误 几个很菜的问题,方分 请教3个sql小问题,谢谢! 时间判断大小的问题!大侠进 跪求!!!跪求!!!优化 急!!!!要显示所有包括空值怎么办
-- Create table
create table DEPT_TEST
(
DEPTNO NUMBER(2) not null,
DNAME VARCHAR2(14),
LOC VARCHAR2(13)
);
alter table DEPT_TEST
add constraint PK_DEPT_TEST primary key (DEPTNO);
-- Create table
create table EMP_TEST
(
EMPNO VARCHAR2(10),
ENAME VARCHAR2(10),
SEX VARCHAR2(9),
DEPTNO NUMBER(2)
);
alter table EMP_TEST
add constraint FK_DEPTNO_TEST foreign key (DEPTNO)
references DEPT_TEST (DEPTNO);SQL> select * from dept_test;
DEPTNO DNAME LOC
------ -------------- -------------
SQL> --插入deptno空的时候可以正常插入
SQL> insert into EMP_TEST values('e005','kk','f',NULL);
1 row inserted
SQL> COMMIT;
Commit complete
SQL> SELECT * FROM EMP_TEST;
EMPNO ENAME SEX DEPTNO
---------- ---------- --------- ------
e005 kk f
SQL> insert into EMP_TEST values('e005','kk','f',10);
insert into EMP_TEST values('e005','kk','f',10)
ORA-02291: integrity constraint (SCOTT_TEST.FK_DEPTNO_TEST) violated - parent key not found
SQL> COMMIT;
Commit complete
SQL> SELECT * FROM EMP_TEST;
EMPNO ENAME SEX DEPTNO
---------- ---------- --------- ------
e005 kk f