« Create a custom Oracle aggregate function that accepts multiple parameters through parameter encapsulation!

To GUID or not to GUID, on Oracle … »

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

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

oracle tip

This entry was posted by Onno on November 17, 2009 at 3:39 pm, and is filed under Programming. Follow any responses to this post through RSS 2.0.You can leave a response or trackback from your own site.

Comments (0)
Related Posts

Type your comment
You may use these HTML tags: <a> <abbr> <acronym> <b> <blockquote> <cite> <code> <del> <em> <i> <q> <strike> <strong>
Comment Feed for this Post

Go to Top