Update issue!

Update issue!

 

  

Hello Experts,



I want to update a table with the specific value.

The problem is that I can't update them all 100000 rows.

I want to update them one by one.



Can anyone provide me a script or a solution how can I do it?



Example:



Update customers set customer_address = 'null' where id > 10000



Thanks



________________________________________
Dritan TABAKU
BCCS Unit, IT Department
AMC, ALBANIA
mobile:+355 (0) 682053050
e-mail:: [Email address protected]




Oracle LazyDBA home page