I need to change the decimal separator from (comma) to (point) inside a "SELECT" query
I do not want to use the sentence "ALTER SESSION". It's possible?Code:select TO_NUMBER('10,35','999G990D00','nls_numeric_characters=''.,''') amount
from dual;
--------------
ORA-01722: invalid number