I am using Oracle 11g, I have to update 7 fields on a table with 14 millions of rows, the updated columns get the new value from functions, the update looks like:

```
update hslak
set HSLAKSTS =  reverseheb(hslaksts) , 
HSLAKSBSTS=reversehebchars(hslaksbsts), 
HSLAKIVTK=reverseheb(HSLAKIVTK), 
HSLAKMKOR=reverseheb(HSLAKMKOR), 
HSLAKIRGTG=reverseheb(HSLAKIRGTG), 
HSLAKMCR= reverseheb(HSLAKMCR),
HSLAKMASL=reverseheb(HSLAKMASL);

```

it run for 6-7 hours and it is not over yet.

Would it be faster to create a new table rather then update it? Would it be better to create a loop and update 100000 records each time and commit after each iteration?