Newbie: Move Data From One Table To Another

From: Jeff <bass2ply_at_sbcglobal.net>
Date: 8 Sep 2004 16:24:00 -0700
Message-ID: <f6f199f0.0409081524.526364d0@posting.google.com>

I have two tables: a transaction table and a transaction history table. At the end of the year, I would like to move the data from the trans table to the hist table via VB .Net. What would be the best way to perform this function using an Oracle statement? Is there a statement that I could run stating select all from Table A and move to Table B?

Any help would be appreciated. Thanks in advance! Received on Wed Sep 08 2004 - 18:24:00 CDT