insert of multiple rows

we have a small delphi program for an import of creditcard-debits into oracle. the program is very simple and inserts ~20.000 datasets. that works very slow because we need one insert per dataset. according to the oracle guide it is possible to insert multiple datasets with one insert-statement.

i tried:
insert into t_timezonematrix (id, name) values (1,'test'), values (2,'test') but it doesnt work (but its strictly like the syntax-diagram)

the only way i found out is an
insert into... select (...) union select(...) ... but thats not very performant.

thanks in advance
steno Received on Fri Nov 24 2000 - 04:32:42 CST