I've been researching methods transferring data from an XML file to an Oracle database. From the many examples I've seen (so far), whether they be PL/SQL or Java, I have only been able to work out how to insert or update the entire file in one go.

However, I would like to create a script that looks at each record to determine if it is already in the database. If it is, it will peform an UPDATE, if it is not, it will peform UPDATE.

Does this sound possible? If so, could anyone recommend which flavour of XDK to use?

Thanks in advance,