Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: insert of multiple rows
Use my TQueryProc component.
You can find it at www.greenhousemm.com
On Fri, 24 Nov 2000 11:32:42 +0100, "steno" <snovotny_at_integro.net> wrote:
>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 - 15:10:52 CST