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: select into statement

Re: select into statement

From: Robert W. Stanford <stanford_at_cableone.net>
Date: 2000/03/01
Message-ID: <38BD4B0A.6DBF2108@cableone.net>#1/1

right, well I don't have that quite at hand at the moment, but the only material that I can find keeps wanting to select it into variables....

so would'nt it be like

select * from table1 into table2 why does that error?

Steve McDaniels wrote:

> This is a very basic SQL command.
>
> I found the syntax on page 4-532 thru 4-538 of the "Oracle 8 Server SQL
> Reference" manual.
>
> You can too.
>
> "Robert W. Stanford" <stanford_at_cableone.net> wrote in message
> news:38BD347E.216CE493_at_cableone.net...
> > I need to copy all of the data from one table to another....
> >
> > what is the select into syntax to do this....????
> >
Received on Wed Mar 01 2000 - 00:00:00 CST

Original text of this message

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