Bulk insert question

From: Fredrik Wahlgren <fredrik.p.wahlgren_at_mailbox.swipnet.se>
Date: Sun, 14 Sep 2003 10:34:10 +0200
Message-ID: <3vp9b.102808$zL.472@news1.bredband.com>

I have a server application in which I need to insert lots of rows into a table. In SQL Server I use the BULK INSERT command. It looks like this

BULK INSERT MyUser.[MyTable] FROM 'C:\MyFile.txt' WITH (FIELDTERMINATOR = '|',ROWTERMINATOR = '\r\n')
¨
This is much faster than having to do lots of INSERT statments. How can I do something similar in Oracle? I understand I can start SQL loader and have it do the insert but that seems rather complicated. Surely there must be a better way, right?

My application is written in C++ and I use ADO. Would I be better off using OCI? Thanks in advance,
Fredrik Received on Sun Sep 14 2003 - 03:34:10 CDT