I've moved...

This blog now has a new home - please update your shortcuts and readers to: www.jeffkemponoracle.com. Sorry for any inconvenience!

Friday, July 24, 2009

Great number formatting trick

An excellent use of Oracle's inbuilt formatting function - much simpler than parsing the input and multiple concatenation operators...

[Full Article]

3 comments:

  1. Good one, would work well for phone numbers as well.

    ReplyDelete
  2. Jeff, I have a blog ( http://my-oracle-10g-tips.blogspot.com/ ) that I like to put things that I'll want to remember. This is one of those things. Would you be ok with me posting this -- or something very similar, and then I'll as 'As seen on http://jeffkemponoracle.blogspot.com/'?

    ReplyDelete
  3. Lynn: I wouldn't want to take credit for it, you can point directly to the stackoverflow link: http://stackoverflow.com/questions/1041415/oracle-formatting-number-as-xxx-xx-xxxx/1042054#1042054.

    ReplyDelete

Note: Only a member of this blog may post a comment.