Use pivot method: http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:766825833740 http://asktom.oracle.com/pls/asktom/f?p=100:11:1183377485437708::::P11_QUESTION_ID:124812348063
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
