Home » Developer & Programmer » Forms » Format of number
Format of number [message #250296] Mon, 09 July 2007 09:21 Go to next message
srinivas.k2005
Messages: 334
Registered: August 2006
Senior Member
Hi,

I have a number of 5digits 12345.
I want to diplay in the format 12,345.00.

I am using the following code to change the format.
To_char(12345,'FM99999999990D00')

But it is displaying as 12345.00 and i am not getting comma.
So to get comma what format mask should i use.

Thanks,
Srinivas

Re: Format of number [message #250305 is a reply to message #250296] Mon, 09 July 2007 10:43 Go to previous message
MarcL
Messages: 455
Registered: November 2006
Location: Connecticut, USA
Senior Member
Why are you using FM ?

Try

 select To_char(12345,'99,999,999,990.00') from dual 
Previous Topic: Using Numeric Keypad in Oracle Forms
Next Topic: Printing Problem
Goto Forum:
  


Current Time: Sun Dec 04 18:29:58 CST 2016

Total time taken to generate the page: 0.07224 seconds