On Sep 4, 6: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
Several issues come to mind: * Column3 makes no sense given the source data -- it isn't the difference or sum of the original column2 values so what purpose does it serve? * There is no discernable order to the final results -- how is this data mapping determined? * There appears to be no real use for such an exercise thus it must be homework. What have you written to accomplish this? You need to post your work thus far; as it's homework we won't do it for you but we can offer suggestions to correct your code. David Fitzjarrell -- 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
