On Oct 6, 4:52 am, SANDEEP REDDY <tosandeepyan...@gmail.com> wrote: > Hi Friends Here Is The Solution For Ur Question > > select a.name NAME1, b.name NAME2 > FROM SAMPLE a, SAMPLE b > where a.name<b.name > > Enjoyyyyy > & > All The Best > > On Sep 1, 7:59 pm, ddf <orat...@msn.com> wrote: > > > > > On Sep 1, 2:46 am, Siva <cs.prasad...@gmail.com> 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- Hide quoted text - > > - Show quoted text -
I think not since the question asks how to INSERT data into a table in that order. As far as we know there is no d -- 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
