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

Reply via email to