Question: I was wondering what would be the preferred technique in Oracle to copy multiple records into a database that ignored duplicate values on a certain index. the statements are stated explicitly in the statement and don't come from another table

```
INSERT INTO EXAMPLE (A, B, C, D) VALUES (null,'example1','example2',EXAMPLE_SEQ.nextval);
INSERT INTO EXAMPLE (A, B, C, D) VALUES (null,'example2','example3',EXAMPLE_SEQ.nextval);
INSERT INTO EXAMPLE (A, B, C, D) VALUES (null,'example4','example5',EXAMPLE_SEQ.nextval);

```

I am currently doing it like this and checking manually, but need to find a way so that these can be handled as scripts

Answer: 
You should look at the `MERGE` syntax.

<http://en.wikipedia.org/wiki/Merge_(SQL>)

```
merge example target
using (select 1 as id, 'a' as val) as source
    on source.id = target.id
    and source.val = target.val
when not matched then
    insert (id, val) values (source.id, source.val);

```
I suggest you to use LOG error clause if you have a goal to provide additional treatment of incorrect data. Please consider <http://www.oracle-base.com/articles/10g/dml-error-logging-10gr2.php> - good example is there.