On Feb 28, 10:16 pm, senthil natarajan <senthilnatarajan...@gmail.com>
wrote:
> hi .. pls try this query...
>
> select rtrim (xmlagg(xmlelement (e,name ||' ')).extract ('//text()'),
> ',') namefrom dept;
>
> i think it is ok for you...
>
> On 2/28/11, Ivan Doroshenko <zider...@gmail.com> wrote:
>
>
>
> > Use pivot method:
>
> >http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:7...
> >http://asktom.oracle.com/pls/asktom/f?p=100:11:1183377485437708::::P1...
>
> > Also there is "pivot" operator in Oracle 11g -
> >http://www.oracle-developer.net/display.php?id=506
>
> > On 28 фев, 07:07, Yuvaraj Sundaresan <yuvarajssundare...@gmail.com>
> > wrote:
> >> Dear Friends,
> >> I need urgent help from u guys, I need to show the output throug
> >> column wise.
>
> >> Eg;
> >> EMP
> >> A
> >> B
> >> C
> >> D
> >> E
>
> >> I need to show the above output as
> >> A B C D E
>
> >> Note: The output should come in different cell not in single cell with
> >> comma separator.
>
> >> Regards
> >> Yuvaraj
>
> > --
> > 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 -
No, it isn't 'okay for you' as the original request was for the data
to be in separate columns, NOT comma-separated in a single list:
"Note: The output should come in different cell not in single cell
with
comma separator.
Regards
Yuvaraj"
Pleaee read posts completely.
The links provided that illustrate use of decode and case, as well as
pivot in 11g, are on the right track as those solutions make columns
into rows (and can make rows into columns) as the original request
indicated.
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
