On Feb 28, 10:16 pm, senthil natarajan <[email protected]> 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 <[email protected]> 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 <[email protected]> > > 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 [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 -
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 [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
