Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Multi Table Insert Distinct

RichardSquiresAug 11 2006 — edited Jul 11 2007
I have a set of data:

ID Name Address
1 Tom 1 The Walk
1 Tom 2 The Run
1 Tom 3 The Sprint

I was hoping to use a multi table insert to insert this information but I wanted to distinct the ID and Name in one table and enter 3 values in the other table. I don't think this is possible. Is there some syntax I am missing that would enable me to do this?

Richard
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 8 2007
Added on Aug 11 2006
6 comments
796 views