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: 404
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

Report message to a moderator

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

Report message to a moderator

Previous Topic: Using Numeric Keypad in Oracle Forms
Next Topic: Printing Problem
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri May 01 04:14:17 CDT 2026
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.