Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!border1.nntp.dca.giganews.com!nntp.giganews.com!local1.nntp.dca.giganews.com!nntp.comcast.com!news.comcast.com.POSTED!not-for-mail NNTP-Posting-Date: Thu, 09 Sep 2004 06:20:58 -0500 Reply-To: "Mark C. Stock" From: "Mark C. Stock" Newsgroups: comp.databases.oracle.misc References: <1094694423.217854@yasure> Subject: Re: Newbie: Move Data From One Table To Another Date: Thu, 9 Sep 2004 07:20:51 -0400 Organization: Enquery, Incorporated X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1437 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 Message-ID: Lines: 37 NNTP-Posting-Host: 68.57.98.189 X-Trace: sv3-vBezu4BW+WVMTdj0RSHlByqiX1i+72dFWlmd5+EmNd3FtQpaJkd8sz20i9pUTXgQveGG1BwPVY+KJev!e3/vRJsto1Cz7jdjZCIqGt1HQCQpbTVKLk8nhJbtvQJuw9IcVWrs17V4peoB X-Complaints-To: abuse@comcast.net X-DMCA-Complaints-To: dmca@comcast.net X-Abuse-and-DMCA-Info: Please be sure to forward a copy of ALL headers X-Abuse-and-DMCA-Info: Otherwise we will be unable to process your complaint properly X-Postfilter: 1.3.13 Xref: dp-news.maxwell.syr.edu comp.databases.oracle.misc:112540 "Daniel Morgan" wrote in message news:1094694423.217854@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 | SELECT * FROM | WHERE ; | | -- | Daniel A. Morgan | University of Washington | damorgan@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