HI,
Please go through http://www.java2s.com/Tutorial/Oracle/0080__Insert-Update-Delete/CopyingRowsfromOneTabletoAnotherINSERTINTOselect.htm <http://www.java2s.com/Tutorial/Oracle/0080__Insert-Update-Delete/CopyingRowsfromOneTabletoAnotherINSERTINTOselect.htm>Thanks and Regards, Venkat On Wed, Sep 22, 2010 at 1:02 PM, Nicholas I <nicholas.domni...@gmail.com>wrote: > Hi, > > i have two tables, > --------------------------------------------------------------- > *table1 > > id type serial, name varchar;* > *-------------------------------------------------------------- > table 2 > > name varchar;* > --------------------------------------------------------------- > > i want to insert the values of table 2 into table 1, with automatic id's. > > insert into table1(select * from table2); > > is not working, how can i append the data to table 1 with auto incremented > or nextval. > > -Nicholas I >
