you can go for bulk insert.

Who i will insert 1 lacks record in a Database table

Question Posted / ramesh

Answer Posted / ramesh

Is This Answer Correct ?

7 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How to update values on multiple rows in oracle?

1034

Explain the use of constraints option in exp command.

1048

What is a oracle database?

1055

What is data block in Oracle?

1116

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

4522

How to end the current transaction in oracle?

1030

how to convert .db (extention) database file into .dmp (extention ) for oracle database ?

2555

How to drop an index in oracle?

1076

Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?

2355

1) Does oracle have any table which contain all the exceptions and it's code internally?

1749

What to do if the binary spfile is wrong for the default instance?

1069

What is the difference between a primary key & a unique key?

1090

How many file formats are supported to export data?

1220

What is Trigger in Oracle?

1171

How to get maxsal , minsal, ename department wise in single query

1549