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 <[email protected]> wrote: > On Nov 3, 9:05 am, Krishna Kumar <[email protected]> wrote: > > > > > > > > > > > Hi > > > Sorting by alphabets will solve your problem > > > On 11/3/11, SANDEEP REDDY <[email protected]> wrote: > > > > Its Oracle 10G > > > > On Nov 2, 6:54 pm, Ahmet Demir <[email protected]> wrote: > > >> Hi, > > > >> what's your db version? > > > >> Ahmet > > > >> 2011/11/2 SANDEEP REDDY <[email protected]> > > > >> > 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 [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 > > > > -- > > > 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-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 [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
