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

Home -> Community -> Usenet -> c.d.o.server -> Re: insert syntax

Re: insert syntax

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 19 Oct 1999 19:49:38 GMT
Message-ID: <380ccb2b.6589282@news.demon.nl>


On Tue, 19 Oct 1999 19:18:25 GMT, Nandakumar <N.Kumar_at_rocketmail.com> wrote:

>Hi
>
>Could someone give the syntax of insert command used to insert all
>the columns and rows of table B into table A?
>
>Table A and B are having identical structure.
>
>Thanks
>--
>Nandakumar
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.

insert into a
select *
from b
/

Hth,

Sybrand Bakker, Oracle DBA Received on Tue Oct 19 1999 - 14:49:38 CDT

Original text of this message

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