My question is actually related to my answer to
248241
What is the default format for to_number? The default format for to_char(number) is TM9, but I cannot figure out the default format for to_number.
Ok, here is my puzzle :
SQL> alter session set nls_numeric_characters=',.';
SQL> select STRING, to_number(string) from x;
STRING TO_NUMBER(STRING)
--------------- -----------------
-0,000000000001 -1,000E-12
999999999999999 1,0000E+15
1e+25 1,0000E+25
try to do this without alter session but with to_number(string,<fmt>,'nls_numeric_characters='',.''');
An ice-cream for the first to find out the right fmt :-)
Regards
Laurent