Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle to_number function pramaters

MikailOct 26 2011 — edited Oct 26 2011

I'm having trouble with TO_NUMBER function second and third parameters. Does one of them depend on the other one? How does nls_params parameter work? I can't understand how the the result of the query

SELECT TO_NUMBER('17.000,23',
'999G999D99',
'nls_numeric_characters='',.'' ')
REFORMATTED_NUMBER
FROM DUAL;

can be 17000.23. Could somebody please explain the process of the above conversion. I looked up the documentation but it's not explanatory eneogh.

P.S. The above query is taken from an Oracle Database SQL Expert Certificate preperation book.

This post has been answered by AlexAnd on Oct 26 2011

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 23 2011

Added on Oct 26 2011

#general-database-discussions

3 comments

239 views