<div>
Even then you should ask the DBA prior to that. Cause even batch updating may be a problem with a small table space.
</div>


Even then you should ask the DBA prior to that. Cause even batch updating may be a problem with a small table space.

<div>
That's OK, I talked to DBA.
</div>


<div>
you'll probably want to commit in larger batches in order to reduce run time and consume fewer resources.<br />
<br />
<br />
for something small like that, assuming no triggers, I would probably do 100,000 or more per commit.<br />
<br />
basically, do as many as your undo space will allow.
</div>


you'll probably want to commit in larger batches in order to reduce run time and consume fewer resources.


for something small like that, assuming no triggers, I would probably do 100,000 or more per commit.

basically, do as many as your undo space will allow.

<div>
<div class="content wysiwyg-content">
Dear Experts,<br />
<br />
I'm very new to PL/SQL. I want to write a procedure to update a table. The table TA fas fields (x number, y varchar(20)) and want to update field y with value 'xyz' if it is null. However since there are hundreds of millions of records with this condition, I would like to use cursors and commit after each update of 1.000 record.<br />
<br />
Could you please help me? &nbsp;<br />
<br />
Best Regards
</div>
</div>


Dear Experts,

I'm very new to PL/SQL. I want to write a procedure to update a table. The table TA fas fields (x number, y varchar(20)) and want to update field y with value 'xyz' if it is null. However since there are hundreds of millions of records with this condition, I would like to use cursors and commit after each update of 1.000 record.

Could you please help me?  

Best Regards

PL/SQL for Updates with Frequent Commit

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.