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 -- 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