Hi
I saw a exmple in
edited: http://www.oraclefrontovik.com/2016/02/using-insert-all-with-related-tables/
but I tried to execute in my computer, and no work
| CREATE TABLE parent_tbl (the_pk | NUMBER PRIMARY KEY, |
| object_id NUMBER); |
| CREATE TABLE child_tbl (the_pk | NUMBER PRIMARY KEY, |
| the_fk | NUMBER, |
| object_name VARCHAR2(30)); |
| |
| |
ALTER TABLE child_tbl
ADD CONSTRAINT child_tbl_fk1 FOREIGN KEY (the_fk)
CREATE SEQUENCE parent_tbl_seq;
| CREATE SEQUENCE child_tbl_seq START WITH 500; | |
INSERT ALL
INTO parent_tbl(the_pk, object_id)
VALUES (parent_tbl_seq.nextval,
INTO child_tbl(the_pk, the_fk, object_name)
VALUES (child_tbl_seq.nextval,
| parent_tbl_seq.currval, |
| object_name) |
SELECT uo.object_id,
FROM user_objects uo;
show me error:
ORA-02291: restrição de integridade myowner.CHILD_TBL_FK1) violada - chave mãe não localizada