Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: transfer data from one table to another

Re: transfer data from one table to another

From: Lee Kyoung Rok <tunnel_at_hananet.net>
Date: Wed, 8 Dec 1999 09:50:11 +0900
Message-ID: <sYh34.2512$sI3.88920@news.hananet.net>

<peerworks_at_my-deja.com>이(가) 아래 메시지를 news:82k1hi$vp6$1_at_nnrp1.deja.com에 게시하였습니다.
> I want to move some of the data from one table to another. What is the
> best choice of SQL statements?
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

Insert into table1
select * from table2
where column1 = value1;
*^^* Received on Tue Dec 07 1999 - 18:50:11 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US