Video : Multitable Inserts


Today’s video takes a look at using Multitable Inserts, which allow an INSERT … SELECT to create rows in multiple destination tables. If you’ve not heard of them, don’t be surprised as they are really new, having only been introduced in Oracle 9i. 🙂

The video is based on this article.

The stars of today’s video are a pitch-perfect choir made up of Debra Lilley, Scott Spendolini, Danny Bryant and Michael Rainey, who are collectively the hottest ticket in town. I have it on good authority they can be booked for weddings, bar mitzvahs and funerals. Incidentally, all four have made appearances in previous videos, which I think makes this their official comeback performance.



Author: Tim...

DBA, Developer, Author, Trainer.