Skip to Main Content

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

~sandy~Sep 6 2013 — edited Sep 18 2013

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.

Comments
Post Details
Added on Sep 6 2013
8 comments
1,766 views