Multi-Table Insert Statements in Oracle

We all know this: if a long-bearded prophet came down from a mountaintop bearing the ten commandments of Oracle programming,...