Re: Newbie: Move Data From One Table To Another

Jeff wrote:

> 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!

The best way would be to NOT use vb.net. In fact I can't imagine any reason why any sane person would want to use a front-end tool to perform a clearly back-end function unless they are being paid by the hour. (Oh boy am I in a good mood this evening.)

Try
INSERT INTO <target_table>
SELECT * FROM <source_table>
WHERE <some_condition_is_true>;

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)