Oracle Stored Procedure Update Table Example Math

How to Update millions or records in a table. Yes this is good example to update the record but. Primary key to update the table through a stored procedure.

1. Sql Stored Procedure Update

I supposed that you update tables a and b with values from c. This is PL/SQL create or replace procedure updateonescan as cursor c is select a.rowid r1, b.rowid r1, c.valuetoget from a join b on (join conditions) join c on (join conditions) where conditions; begin for r in c loop update a set coltoupdate=r.valuetoget where rowid=r1; update b set coltoupdate=r.valuetoget where rowid=r2; end loop; end; You have the advantage of single scan of source tables. UPDATE: You can do it even in oracle SQL, but is more restrictive(you'll see when you try).

Sql Stored Procedure Update

But this can be faster. Is a UPDATE SELECT statement: Create or replace Procedure updateselect AS BEGIN update (select a.coltoupdate as c1, b.coltoupdate as c2, c.valuetoget v1 from a join b on (join conditions) join c on (join conditions) where conditions) set c1 = v1, c2 = v2; END.