For UPSERT method, it should only insert data that does not exist in the database.
My problem is, why it INSERT duplicate value into the database when i rerun it again?
Plz help!?
![Confused :?](./images/smilies/icon_confused.gif)
![Confused :?](./images/smilies/icon_confused.gif)
Moderators: chulett, rschirm, roy
duplicate based on what???. try trimming the values the key columns before inserting .weiven wrote:Im trying to INSERT value from Sequential file to Oracle9i using method UPSERT.
For UPSERT method, it should only insert data that does not exist in the database.
My problem is, why it INSERT duplicate value into the database when i rerun it again?