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!

how to update first 1000 record, then next 1000 record plz help meeeee

729927Apr 10 2010 — edited Apr 10 2010
  friends i need to update my employee master table which having some 50000+ record so i want to update it in 1000 records one time 
  because it is having trigger which calling some function and procedure ..

  i tried with this 
  
--update prm_m_employee 
--set PMEP_BASIC_FLAG = 'Y'

  select rownum , pmep_emp_id , pmep_psno 
from prm_m_employee
where exists ( select distinct 'x' 
               from prm_m_chart_17 
               where  PMC17_F17_CODE  = pmep_emp_id 
               and PMC17_HOP_CODE = 5 )
and rownum between 1 and  1000

but  for next thousnd it is not returning 

 please give any suggestion 
   
Edited by: user12108669 on Apr 10, 2010 8:27 AM
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 8 2010
Added on Apr 10 2010
4 comments
2,331 views