this blog is intended to be a place to store code snippets, examples, notes...
in order to have them handy and to quickly find during the everyday work
Search This Blog
Thursday 10 December 2009
Oracle parse number
how to parse as a number the string 1670.0000
TO_NUMBER('1670.0000','999999999999D0000','NLS_NUMERIC_CHARACTERS=''.,''')
note that the substring ., is enclosed within single quotes
No comments:
Post a Comment