各位大虾,本人刚学oracle,在SQL/PLUS中调试,遇到如下的错误,
望大家帮忙分析分析,感谢万分!SQL> delete from employees where last_name not like 'A%';
delete from employees where last_name not like 'A%'
*
ERROR 位于第 1 行:
ORA-02292: 违反完整约束条件 (HR.DEPT_MGR_FK) - 已找到子记录日志
SQL> delete from employees where job_id in
2 (select job_id from jobs where job_title like 'A%');
delete from employees where job_id in
*
ERROR 位于第 1 行:
ORA-02292: 违反完整约束条件 (HR.JHIST_EMP_FK) - 已找到子记录日志
望大家帮忙分析分析,感谢万分!SQL> delete from employees where last_name not like 'A%';
delete from employees where last_name not like 'A%'
*
ERROR 位于第 1 行:
ORA-02292: 违反完整约束条件 (HR.DEPT_MGR_FK) - 已找到子记录日志
SQL> delete from employees where job_id in
2 (select job_id from jobs where job_title like 'A%');
delete from employees where job_id in
*
ERROR 位于第 1 行:
ORA-02292: 违反完整约束条件 (HR.JHIST_EMP_FK) - 已找到子记录日志
补习一下数据库基础吧。这次的问题涉及到外键。你在删除的母表,有子表在参照中。
看来,得先去搞清楚一下这些表关系啦!