Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Q: formatting the results
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!
Received on Tue Jun 15 2004 - 13:36:59 CDT