Re: Newbie: Move Data From One Table To Another

"Daniel Morgan" <damorgan_at_x.washington.edu> wrote in message news:1094694423.217854_at_yasure...
> 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

Here is a reason:

Hi, all,

Please help me. I have always used a hammer in my occupation. It works great for nails (many different kinds of nails, in fact), which is all I've used it on till now. I now have a box of screws I need to apply. Could someone please tell me the best technique for using my hammer on the screws? Thanks!

> unless they are being paid by the hour. (Oh
> boy am I in a good mood this evening.)

And you thought _you_ were in a bad mood! Received on Mon Sep 13 2004 - 09:08:11 CDT