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.