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