Skip to Main Content

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!

commit for every 1000 records in Insert into select statment

SmileFeb 15 2013 — edited Feb 15 2013
Hi I've the following INSERT into SELECT statement .
The SELECT statement (which has joins ) has around 6 crores fo data . I need to insert that data into another table.

Please suggest me the best way to do that .
I'm using the INSERT into SELECT statement , but i want to use commit statement for every 1000 records .

How can i achieve this ..
insert into emp_dept_master 
 select e.ename ,d.dname ,e.empno ,e.empno ,e.sal 
   from emp e , dept d
  where e.deptno = d.deptno       ------ how to use commit for every 1000 records .
Thanks
This post has been answered by Karthick2003 on Feb 15 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 15 2013
Added on Feb 15 2013
9 comments
20,877 views