Erwin Van de Velde wrote: > Hi, > > I have to copy data from one table to another, and I was wondering if > there is an easier way to do that than to have a lot of inserts one after > another.
insert into target_table select * from source-table where ...; Björn Lundin ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings