Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Bulk inserts
"L.R.M" <rbas_at_multiweb.nl> wrote in message news:<2uXe7.44039$w91.6874873_at_news.quicknet.nl>...
> Is there a way to manage bulk inserts through sql statements, smething like
> bulk insert into table1 from \\Net10\customers.txt
>
> Any help appreciated.
>
> Thanks,
>
> Richard
Richard, look in the PL/SQL manual at bulk inserts. But you have to read the data into a pl/sql table (array) and then issue a single insert to Oracle telling it to insert the set.
You may also want to consider use of the SQLLDR utility (see Utilities manual) which can take a delimited or fixed data position file and insert it into a table. The direct path load is a form of bulk insert.