Re: Q: formatting the results

From: Holger Baer <holger.baer_at_science-computing.de>
Date: Wed, 16 Jun 2004 14:17:00 +0200
Message-ID: <capdns$on7$2@news.BelWue.DE>

Vince Laurent wrote:
> I have a query which looks like this:
>
> SQL> select count(status) from v$session group by status;
>
> 15
> 623
>
> But I would like the output to look like this:
>
> 15 623
>
> And I would like to add
>
> SQL> select to_char(sysdate, 'HH24:MI') from dual;
>
> 13:35
>
> to the line as well. So I finally get something like:
>
> 13:35 15 623
>
> Ideas? Web sites/docs to check out?
> Thanks!
>

What you want to do is a pivot table. Search for this phrase on http://asktom.oracle.com

HTH Holger Received on Wed Jun 16 2004 - 07:17:00 CDT