Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: insert syntax
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