Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to insert a lakhs of records into a table (say 6 lakhs records into a table) by using the loopin

unknown-2962860Jun 23 2015 — edited Jun 23 2015

How to insert the bulk records into the table by using the loop.

Say the table name is employee and my requirement is to insert the 6 lakhs record into the table.

And once after inserting I need to check the records inserted into the table by using select query..

So I need a query to insert the 6 lakh records into the table by using the looping statement.

Regards,

Vinoth.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 21 2015
Added on Jun 23 2015
13 comments
4,814 views