Skip to Main Content
Forums

SQL & PL/SQL

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!

to_number & NLS_NUMERIC_CHARACTERS

66213Feb 2 2005 — edited Feb 2 2005
Hello,

Could you help me ?

select to_number('3,2', '999D99', ' NLS_NUMERIC_CHARACTERS = '',.''') from dual
return "3,2"

but

select to_number('3.2', '999D99', ' NLS_NUMERIC_CHARACTERS = '',.''') from dual
return "32", but I hope invalid number exception

Thanks in advance.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 2 2005
Added on Feb 2 2005
1 comment
921 views