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 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 Received on Thu Sep 09 2004 - 06:20:51 CDT