Tuesday, April 04, 2006

Work around

select TO_NUMBER ('13,000.09', '99G999D99','nls_numeric_characters = ''.,''') from dual

select TO_NUMBER ('13.000,09', '99G999D99','nls_numeric_characters = '',.''') from dual

0 comments: