Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: INSERT INTO STATEMENT
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...Received on Thu Nov 14 2002 - 03:33:53 CST
> 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
>
>