This discussion is archived
8 Replies Latest reply: Sep 18, 2013 7:06 AM by SomeoneElse RSS

Need help in SQL Query: Update a row in a table & insert the same row into another table

~sandy~ Newbie
Currently Being Moderated

I want to update a row in a table say Table A and the updated row should be inserted into another table say Table B. I need to do it in a single SQL query and i don't want to do it in PL/SQL with triggers. And i tried with MERGE statement but its working with this scenario. (Note: I'm using Oracle Database 10g Enterprise Edition Release 10.2.0.1.0).

Thanks in Advance.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points