wafa khan wrote:Hi thank you for replayin but i don't understand what you mean
i change code at this query but they give me this error:
java.sql.SQLException: Column count doesn't match value count at row 1
Did the code in your first post produce the same error?
In any case, please post the stack trace (use
printStackTrace() method of the
SQLException to obtain it). Make sure the code you posted here contains the line where the error occurred, and let us know which line it was.
I execute program many times so every time the same data will be inserted i have repetition for that i want use Insert where not exists
This is what the MERGE statement is for. Have you read the documentation I've provided?
The way you're doing it should work as well, though (just tried it in principle in sql*plus). It's just less usual, since MERGE serves the same purpose.
We can try to solve the error first and return to the possible use of MERGE later. Your first post didn't indicate where the problem was, so I've answered it in perhaps a bit too much broad way