update statement PL/SQL

I'm a newbie here. I try to update data from 1 table from another table. So I used cursor to update my employee table on Total_sale column = amount column on Sales Table where employee.empid = sales.empid. The problem is for 700,000, it took 2 hours to update. That's too long. Any Ideas or some sample codes would really helpful.

Thanks Received on Wed Apr 27 2005 - 19:43:30 CDT