in reply to copying mysql table data to oracle table

The "upsert" statement in Oracle is call MERGE

Please do not use a variable for the table name. That is some dangerous dynamic sql there.

  • Comment on Re: copying mysql table data to oracle table