hey it can be done using analytical functions sql On Thu, Oct 6, 2011 at 3:34 PM, ddf <orat...@msn.com> wrote:
> > > 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 > -- 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
