On Sep 1, 2:46 am, Siva <[email protected]> wrote: > Hi All, > > In Table1 I have data like this. > > Column1 > ----------------- > > Record1 > Record2 > Record3 > Record4 > > And in Table 2 the data has to be inserted in below manner. > > Column1 Column2 > ------------------------------- > Record1 Record2 > Record1 Record3 > Record1 Record4 > Record2 Record3 > Record2 Record4 > Record3 Record4 > > Please let me know how to achieve this. > > Regards.
You logically think through the problem and arrive at a solution. Since this is probably homework you should post what you've done to achieve these results. Once we see your work we can correct areas, as necessary, to lead you to the answer. 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
