Whenever you're ready, walk me through how you'd approach this.
How does Oracle handle database transactions, and what happens if a transaction fails mid-way?