difference between update actions in OCI & ODBC

[venkat n]

Acually I want the main difference between replace all the rows with existing rows and clear rows and inserting new rows
what is the b/g process in these two update actions?
Why they are used two things for smae action?
Why the ODBC stage update actions are different , OCI stage update actions are different ?
both are doing same thing why those update actions are different ?

[ray.wurlod]

This has been discussed many times. Searching the forum will answer your question. So will consulting the on-line help for the stage types in question.

[ray.wurlod]

We prefer to avoid the "double action" methods replace (= delete then insert), insert or update, update or insert; for performance reasons.