Home » SQL & PL/SQL » SQL & PL/SQL » Number Format???
Number Format??? [message #951] Thu, 14 March 2002 23:42 Go to next message
homer
Messages: 17
Registered: October 2001
Junior Member
I have a SQL request

select sum(toto) result from my_table.

whose the result is:

result
-------------

15.2

and I want to see 15.20.

Can you tell me what I can do.
Thanks U a lot

herve.arnaud@juris-classeur.com

Report message to a moderator

Re: Number Format??? [message #952 is a reply to message #951] Fri, 15 March 2002 00:46 Go to previous message
pratap kumar tripathy
Messages: 660
Registered: January 2002
Senior Member
try this

select to_char(sum(toto)),'99.99') result
from my_table.

OR

set numformat 99.99
select sum(toto) result from my_table.

Report message to a moderator

Previous Topic: virtual table...
Next Topic: REPORT IN CHARACTER MODE (URGENT)
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 18 22:13:47 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.