Re: Inserting Rows in Bulk

Creating a text file and then using SQL Loader to upload the data to database is a better choice if the data is very huge.

Regards
John Huang
OCP - DBA
email : dba_huang_at_hotmail.com

"FaheemRao" <faheemrao_at_yahoo.com> wrote in message news:43b58913.0110021349.2dc275f3_at_posting.google.com...
> I want to insert many rows in one Database Call.
>
> like in the Insert SQL statement
>
> insert table_name values(........);
>
> but this will insert only one row in the database.
>
> My Application code is inserting a huge amount of data at one time, so
> it is taking a longgggg time to insert thousands of records.
>
> My application is connected to Oracle through ODBC.
>
> so I need something through which I can insert X number of rows at one
> database call so to take les time.
>
> Any help wuld be apprecited..
>
>
> Thanks
>
>
> Faheem Rao
Received on Wed Oct 03 2001 - 02:13:24 CDT