Tuesday, 13 August 2013

VB.NET: insert multiple rows into an oracle database using ODP.NET

VB.NET: insert multiple rows into an oracle database using ODP.NET

I have some records from a SqlCe as a result of a query similar to this:
select *
from tableName
where condition
Now, I want to insert those records into an existing table in a Oracle
database that already contains data. I am using ODP.NET. Which is the best
way (efficient) to insert all them at once and using a transaction to
rollback if any problem appears?

No comments:

Post a Comment