Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: print horizontal
Raja,
Description of various string/number aggregation techniques are
available at oracle-base website:
http://www.oracle-base.com/articles/10g/StringAggregationTechniques.php
On 1/24/06, raja rao <raja4list_at_yahoo.com> wrote:
> HI Team,
>
> Can someone help me to print the below in horizontal.
>
> SQL> select * from v2h;
> X
> ----------
> 1
> 2
> 3
> 4
> 5
>
> I need the values tobe printed like this:
>
> 1 2 3 4 5
>
> can someone give me some clue on this without using pl/sql.
>
> Thanks in adv,
> Raj
>
-- Best regards, Edgar Chupit callto://edgar.chupit -- http://www.freelists.org/webpage/oracle-lReceived on Tue Jan 24 2006 - 05:15:01 CST
![]() |
![]() |