Re: Query Question

Mtek <mtek_at_mtekusa.com> wrote in news:c80264dd-be17-4754-a00e-483b4182e855 @l28g2000prd.googlegroups.com:

> Hi,
>
> Is it possible to return all rows from a query on one line?
>
> I have this query:
>
> SELECT cnt || ':' || t_id
> FROM (SELECT COUNT(*) cnt, t_id
> FROM zc_body zb, zc_type zt
> WHERE zb.t_id = zt.id
> group by t_id);
>
> It returns data like this:
>
> 86:3
> 994:7
> 99:18
> 38:27
> 45:36
>
> However, they want it in one line: 86:3,994:7,99:18,38:27,45:36
>
> Can this be done?
>
> Thanks!
>
> John
>

I have no idea about ultrasearch or workplace manager, but with plain old PL/SQL your can do it easily. Received on Thu Jun 19 2008 - 16:08:48 CDT