Re: select into statement

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 Thu Mar 02 2000 - 00:00:00 CST