oracle sql technique prevaricate stuffing trans log

newish seer programming (from sybase ms sql server). "oracle way" prevaricate stuffing trans record infinite updates?

in specific case, i'm doing an transform potentially unequivocally infinite array rows. here's approach:

update my_table
set a_col = null
where my_table_id 
(select my_table_id my_table where some_col < some_val rownum < 1000)

...where i govern inside loop until updated quarrel count zero,

is best approach?

thanks,