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 Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to oracle-plsql-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en
