This article examines how to loop through multiple tables to process the data.

This story continues at
http://www.dbasupport.com/oracle/ora...ble_loop.shtml