[SQL] Oracle SQL : Batch insertion into multiple tables based on a single result set

I have written a computationally expensive select query which produces a certain result set. I need to insert this result into a table and the aggregates of this result set into another table. I need to do those in a single transaction instead of using two transactions as it can lead to inconsequential data issues.

Request you to please help me out on how i can do this in Oracle.

Continue reading...