Re: insert syntax

From: Bessenyei Zsolt <bessenyei_at_flexum.hu>
Date: Wed, 20 Oct 1999 10:48:32 +0200
Message-ID: <380D81E0.BFFF2616@flexum.hu>

Hello,

I can't try on Oracle, but in MS SQL and Sybase it works:

INSERt INTO table_A SELECT * FROM table_b

Zsolt Bessenyei

Nandakumar 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.
Received on Wed Oct 20 1999 - 03:48:32 CDT