This really strikes me as a homework question (and not one with a lot of utility in the real world)
Can we see what you have come up with so far? We are happy to help someone that is stuck but we don't particularly like to do someone's homework for them. After all, we might have to work with you out here in the real world and it would be nice to know that you did some of your work for yourself before asking your coworker. Rob On Sep 4, 9:02 am, Siva <[email protected]> wrote: > Hi, > > I have data in *Table 1 *as below. > > Column1 Column2 > ------------ ------------- > A 10 > D 78 > C 08 > B 90 > E 05 > > and this information has to be inserted into* Table 2* as shown below. > > Column1 Column2 Column3 > ------------- ------------- ------------- > A D 10 > A C 10 > A B 10 > A E 10 > D C 78 > D B 78 > D E 78 > C B 08 > C E 08 > B E 90 > > Please help me how to code this. > > Regards, > Siva -- You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en
