check duplicates before insert into a table

check duplicates before insert into a table

 

  

Hi,



can you please give me a hint,

I have to insert data from an external table into some internal tables.



How do I check, if the recordset isn't already in the internal db?

I have a unique index across 4 columns - if the recordset is already in the
db - I must insert this recordset into a table called DUPLICAT.



Thanks for your help.




Oracle LazyDBA home page