Inserting Rows in Bulk

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 Tue Oct 02 2001 - 16:49:19 CDT