Re: copying mysql table data to oracle table

On MySQL there is a internal function INSERT ... ON DUPLICATE KEY UPDATE Syntax give it a try.

Update: I do not have an oracle table to test if the same function works so I can not verify it but I hope it does.

Let us know if this is working for you. Looking for your update, BR.

Seeking for Perl wisdom...on the process of learning...not there...yet!

Comment on Re: copying mysql table data to oracle table Select or Download Code

Replies are listed 'Best First'.
Re^2: copying mysql table data to oracle table by soonix (Chancellor) on Aug 24, 2017 at 11:35 UTC
I second this. However, a quick google for oracle insert or update suggests "UPDATE, if no records affected then INSERT" might be easier to implement with DBD::Oracle; the `sql%rowcount` being available in (statement handle)->rows	[reply] [d/l]
Re^3: copying mysql table data to oracle table by thanos1983 (Parson) on Aug 24, 2017 at 13:23 UTC
Hello soonix, You are right, I should have Googled it. Thanks for the time and effort, BR. Seeking for Perl wisdom...on the process of learning...not there...yet!	[reply] [d/l] [select]