Re: Newbie: Move Data From One Table To Another

Mark C. Stock wrote:

> "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 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)
> |
>
> dan, maybe the OP's development environment is VB .net -- you got to issue
> the SQL from somewhere
>
> ++ mcs

Maybe. But the statement still belongs in the backend ... and at most the VB.net should run a stored proc. The Oracle statement absolutely does not belong in VB which is what I was reacting to.

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