8 Replies Latest reply: Sep 18, 2013 9:06 AM by SomeoneElse RSS

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


      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

      Thanks in Advance.