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!

Convert to number

527448Nov 26 2007 — edited Nov 26 2007

I have a column char(10) that can have a number or null. I need to convert to number, but the problem is that if the numeric value is in the format "###.##" I get an exception, because my database is expecting a number in the format "###,##" (comma instead of period). Is there a work-around for this?
A universal-independet way to work with these types of columns?

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 24 2007

Added on Nov 26 2007

7 comments

834 views