Oracle Tip: The decimal marker to a dot, and the thousands marker to a comma in to_number().

November 17, 2009 by Reboot · Leave a Comment

to_number(t.yournumbercolumn,'9G999G999D99','NLS_NUMERIC_CHARACTERS='',.''')

See also:

Oracle NLS_NUMERIC_CHARACTERS
http://download.oracle.com/docs/cd/B28359_01/olap.111/b28126/dml_options072.htm

Filed under Programming · Tagged with oracle, tip

Search for:
Upcoming
- Starcraft 2 (July 27)
Tags
api calendar codegeneration diacritic favicon forum fun Gaming google hidden java javascript jquery json lol mashup oracle patch php pl/sql plugins python reddit rest skins snails soccer starcaft supcom testing timezone tip ui warning webdesign widget youtube zend
Onno's Tweets
- http://open.spotify.com/track/2O8YJmOg9lOgn5JNHF9Qi9 Spotify: Randy Newman – You've Got A Friend In Me !!! 11:21:44 AM July 26, 2010 from web
- More "hidden" skins in the new LoL patch, yay!! http://bit.ly/cWlwkn 09:16:29 PM June 24, 2010 from web
- I smell a bit like raw sewage ;-) Team building day was kinda fun though! 09:00:30 PM June 23, 2010 from Twitter for iPhone
- #dpc10 second day, good start, lets keep this up for the rest of the day. 07:42:25 AM June 12, 2010 from Twitterrific
- Congratz RIOT on finishing the server migration already, I've got STATS! (http://blog.ingol.nl) 06:44:55 AM May 26, 2010 from Twitterrific
Meta
Archives
- July 2010 (2)
- June 2010 (7)
- May 2010 (6)
- April 2010 (6)
- March 2010 (1)
- February 2010 (3)
- January 2010 (6)
- December 2009 (3)
- November 2009 (3)
- October 2009 (10)
- September 2009 (7)
- August 2009 (1)
- July 2009 (1)
- April 2009 (4)
- March 2009 (5)
- February 2009 (7)
- January 2009 (5)
- December 2008 (3)
- July 2007 (1)
November 2009

M T W T F S S

« Oct Dec »

1

2 3 4 5 6 7 8

9 10 11 12 13 14 15

16 17 18 19 20 21 22

23 24 25 26 27 28 29

30
Blogroll
Photos