Categories
How to set float number separator instead of "," to "." in Oracle DB?
Query: select 20.2 from dual Returns: 20,2 How can I make the separator "." instead of "," by default for all requests with a float number?
select 20.2 from dual
Answer the question
In order to leave comments, you need to log in
Решение найдено:alter session set NLS_NUMERIC_CHARACTERS='.,'
alter session set NLS_NUMERIC_CHARACTERS='.,'
Didn't find what you were looking for?
Ask a Question
731 491 924 answers to any question