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 INTO STATEMENT

Re: INSERT INTO STATEMENT

From: Vladimir M. Zakharychev <bob_at_dpsp-yes.com>
Date: Thu, 14 Nov 2002 12:33:53 +0300
Message-ID: <aqvqq6$r9g$1@babylon.agtel.net>


Take some time to familiarize yourself with SQL Reference. Your first INSERT is missing FROM in subquery and Oracle should've said that to you in error message you got when trying to execute it.

--
Vladimir Zakharychev (bob@dpsp-yes.com)                http://www.dpsp-yes.com
Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
All opinions are mine and do not necessarily go in line with those of my employer.


"Peta Griffith" <peta_at_dataspeed.com.au> wrote in message
news:_8DA9.76154$g9.214986_at_newsfeeds.bigpond.com...

> 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 Thu Nov 14 2002 - 03:33:53 CST

Original text of this message

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