Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: SQLPLUS: how to make results appear in a line fashion
AleX <korrozia_at_my-deja.com>ÀÌ(°¡) ¾Æ·¡ ¸Þ½ÃÁö¸¦
news:7niumh$83u$1_at_nnrp1.deja.com¿¡ °Ô½ÃÇÏ¿´½À´Ï´Ù.
> Hi!
>
> I need to have this done.
>
> I'm in sqlplus 8.0.5
>
> I have a query like this:
>
>
> FLO> select col2 from joe;
>
> COL2
> -----
> 2
> xzc
> ccxc
> cxcx
> xcx
> zxz
>
> 6 rows selected.
>
> Is there a way to make the results appear like this
>
>
> FLO> select col2 from joe;
>
> COL2
> -----
> 2, xzc, ccxc, cxcx, xcx, zxz
>
> 6 rows selected.
>
> Any help is appreciated!
>
> --
> Alex Shterenberg
>
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Make a view.
create or replace view view_name
as select col2 from joe where col2 = '2'
union
...
select col2 from joe where col2 = 'zxz';
Received on Mon Jul 26 1999 - 22:22:24 CDT
![]() |
![]() |