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: 64152
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: Sat Dec 10 02:47:46 CST 2016

Total time taken to generate the page: 0.09408 seconds