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
You're going to have to declare string variable and a cursor.
For values after the first one, prepend a comma before appending the return
value.
The syntax is an exercise for the student.
--rn.
AleX <korrozia_at_my-deja.com> wrote in message
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.
Received on Sun Aug 01 1999 - 17:23:00 CDT