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