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?