Home » SQL & PL/SQL » SQL & PL/SQL » number format (oracle 9i)
number format [message #336921] Tue, 29 July 2008 06:35 Go to next message
tamil
Messages: 22
Registered: April 2007
Location: chennai
Junior Member
hi,

i write a query as
select mar from cb;

result:
------
59
20.04
.1
.07
.
.
etc

i want two digit format like
59.00
20.04
.10
.07

how will be write a qurey
pls help me
Re: number format [message #336922 is a reply to message #336921] Tue, 29 July 2008 06:44 Go to previous message
Michel Cadot
Messages: 64603
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
TO_CHAR

Regards
Michel
Previous Topic: sql update in a loop
Next Topic: Grouping in sets of 100 rows
Goto Forum:
  


Current Time: Thu Mar 23 17:13:09 CDT 2017

Total time taken to generate the page: 0.10616 seconds