I Already Posted The Example On How to diaplay the records A single column Of all Records To be displayed in a single row...i.e.,Multiple rows in a single row..
I am Using Oracle 10g Ver 2 (10.1.0.2) On Nov 3, 10:31 pm, ddf <orat...@msn.com> wrote: > On Nov 3, 9:05 am, Krishna Kumar <dba.krishnaku...@gmail.com> wrote: > > > > > > > > > > > Hi > > > Sorting by alphabets will solve your problem > > > On 11/3/11, SANDEEP REDDY <tosandeepyan...@gmail.com> wrote: > > > > Its Oracle 10G > > > > On Nov 2, 6:54 pm, Ahmet Demir <ad1987s...@gmail.com> wrote: > > >> Hi, > > > >> what's your db version? > > > >> Ahmet > > > >> 2011/11/2 SANDEEP REDDY <tosandeepyan...@gmail.com> > > > >> > There are n number of columns with n number of records . > > > >> > Example > > > >> > Col1 Col2 Col3 > > >> > -------- ------- ---------- > > > >> > 1 APPLE .. > > >> > 2 BALL ... > > >> > 3 CAT ... > > >> > 4 DOG ... > > >> > 5 ELEPHANT ... > > >> > . > > >> > . > > >> > . > > > >> > Select col2 from tab_name; > > > >> > APPLE > > >> > BALL > > >> > CAT > > >> > DOG > > >> > ELEPHANT > > >> > .. > > >> > .. > > > >> > I want To display Above Records In The Following Format > > > >> > APPLE BALL CAT DOG ELEPHANT ... > > > >> > -- > > >> > 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-Hide quoted text - > > > - Show quoted text - > > Please post an example to show how this could be done. > > 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
