To set in a single session the decimal separator, for example when you need to cast some string in numbers you can use the next istruction :
|
1 |
ALTER SESSION SET NLS_NUMERIC_CHARACTERS ='. '; |
in this case the “decimal separator” is the point “.”. if you want the parameter is set inside a procedure or a function you can write like…
Leggi tutto
