Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: select into statement
oh, thank you thank you, thank you thank you...perfect. yes yes....thank you sooo much.
"C. Ferguson" wrote:
> Hi Robert,
> insert into table2 select * from table1;
> if the table structures are identical, or you can pick off the source
> columns individually
> insert into table2 select col1, col2, col3 from table1 where ...;
>
> And yes I understand your need when you can't get to the documentation.
>
> cheers,
> cindy
>
> "Robert W. Stanford" wrote:
>
> > 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