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