pl/sql dup_val_on_index

i have a pl/sql statement

that inserts into a table, the select brings back about 1000 rows, but the table already has 900 of the rows and a unique constraint on it.

i want the pl/sql to disregard any row that is already there but insert the ones that arent.

any ideas?

begin

insert into select ...

exception when dup_val_on_index
null;

end; Received on Tue Dec 06 2005 - 06:05:16 CST