这里是向部门表插于一条数据,却查看不到,为什么啊?
CREATE OR REPLACE PROCEDURE dept_add
IS
BEGIN
INSERT INTO departments
VALUES(500,'products',100,1007);
COMMIT;
END;
SELECT * FROM departments
WHERE department_id = 500;
CREATE OR REPLACE PROCEDURE dept_add
IS
BEGIN
INSERT INTO departments
VALUES(500,'products',100,1007);
COMMIT;
END;
SELECT * FROM departments
WHERE department_id = 500;
楼主存储过程有执行吗?exec dept_add;在查询看看..
VALUES(500,'products',100,1007);
时,提示:ORA-02291:integrity constraint <HR.DEPT_LOC_FK> violated-parent key not found
怎么回事啊?
Cause: A foreign key value has no matching primary key value.
应该是你插入的时候外键约束错误
IS
BEGIN
INSERT INTO departments
VALUES(280,'products',100,1000);
COMMIT;
END;
/
对于主外键的关系,你自己看下吧 很简单的,就不细说了
主外键的使用:外键在执行操作时如insert 在应用外键的字段上必须插入主键对应字段已有的数据.