Re: [SQL] insert into help

2010-09-24 Thread James Kitambara
because of    DEFAULT nextval('table1_id_seq'::regclass)   James Kitambara Computer System Analyst and Programmer Bank of Tanzania, P.O. Box 2939, Mobile : +255 71 3307632, Dar es Salaam, Tanzania.   --- On Wed, 22/9/10, Guillaume Lelarge wrote: From: Guillaume Lelarge Subje

Re: [SQL] insert into help

2010-09-22 Thread venkat
HI, Please go through http://www.java2s.com/Tutorial/Oracle/0080__Insert-Update-Delete/CopyingRowsfromOneTabletoAnotherINSERTINTOselect.htm Thanks and Regards, Venkat On Wed,

Re: [SQL] insert into help

2010-09-22 Thread Guillaume Lelarge
Le 22/09/2010 09:32, Nicholas I a écrit : > Hi, > > i have two tables, > --- > *table1 > > id type serial, name varchar;* > *-- > table 2 > > name varchar;* >

[SQL] insert into help

2010-09-22 Thread Nicholas I
Hi, i have two tables, --- *table1 id type serial, name varchar;* *-- table 2 name varchar;* --- i want to insert