Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Q: formatting the results

Q: formatting the results

From: Vince Laurent <vincelaurent_at_sbcglobal.net>
Date: Tue, 15 Jun 2004 18:36:59 GMT
Message-ID: <s4guc0dnqc6kup45raa9sqkjutgf5u8t9p@4ax.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US