In MySQL for example you can do updates using inner joins between tables, but you can't do this in PL/SQL. So one of the most efficient approaches in my opinion is to use the Cursor and For Loop ...

possible in PL/SQL (and any other language). That way, you give the compiler maximum freedom to optimization. -- Create Driver for Test I generate 100,000 rows for my cursor using by CONNECT BY LEVEL ...

An application can use several cursors concurrently. Each cursor requires its own set of DECLARE CURSOR, OPEN, CLOSE, and FETCH statements. See "Example Cursor Program" for an example of how an ...