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!

update in batches

DBQuestFeb 1 2016 — edited Feb 1 2016

Hi,

I have a table TRANSACTIONS with 1 million records, In which i want to update AMOUNT column with AMOUNT * 0.90.

UPDATE TRANSACTIONS

SET amount = amount * 0.90;

But i want to update 10000 records for each iteration, instead of updating all the records at a time. Transaction_id is the unique column.

Please advise.
This post has been answered by Solomon Yakobson on Feb 1 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 29 2016
Added on Feb 1 2016
5 comments
524 views