Re: INSERT INTO STATEMENT

From: Laly <lalystar_at_free.fr>
Date: Thu, 14 Nov 2002 05:09:35 +0100
Message-ID: <3dd321f0$0$22990$626a54ce@news.free.fr>

Hi,

The first query is nearly ok, the from is missing : INSERT INTO TEST1 ( ID,DESCRIPTION)
SELECT TEST.ID,TEST.DESCRIPTION
FROM TEST
WHERE TEST.ID =5 Laly.
----- Original Message -----
From: "Peta Griffith" <peta_at_dataspeed.com.au> Newsgroups: comp.databases.oracle.server Sent: Thursday, November 14, 2002 2:47 AM Subject: INSERT INTO STATEMENT

> Hi All,
>
> I am have trouble coding a Insert Into Statement
>
> the below statements is basic example of the SQL
>
> INSERT INTO TEST1 ( ID,DESCRIPTION) SELECT TEST.ID,TEST.DESCRIPTION WHERE
> TEST.ID =5
>
> INSERT INTO TEST1 ( ID,DESCRIPTION) VALUES(SELECT TEST.ID,TEST.DESCRIPTION
> WHERE TEST.ID =5)
>
>
> i am trying to copy the detail from on table to another with exact
> structures
> if anyone knows the correct syntax or a better method for this it would be
> much appreciated
>
> Cheers
> Paul
>
>
Received on Wed Nov 13 2002 - 22:09:35 CST