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

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.

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


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


 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: Fri Jul 21 00:09:30 CDT 2017

Total time taken to generate the page: 0.12847 seconds