Insertion of Data with foreign key constraint

User_STYEH

Any constraint if violated during the bulk insertion, will insert records satisfying the constrants or abort the complete insertion.

Example: I have 100 rows and I wrote an insert statement with select.

insert into table_2(col1, col2, col3) select * from table1;

say suppose col1 having a foreign key constraint, a row smewhere in the middle is not satisfying this constraint, so will my insert query be

1) inserting all other records,

2) or records coming previous to the record having problem,

3) or no records will be inserted

User_STYEH

..

cormaco

The answer is:

3) or no records will be inserted

unless you use DML Error Logging. You can read about it here:

https://oracle-base.com/articles/10g/dml-error-logging-10gr2