N
N
Noffily2015-03-27 10:51:04
PHP
Noffily, 2015-03-27 10:51:04

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?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
N
Noffily, 2015-03-27
@Noffily

Решение найдено:
alter session set NLS_NUMERIC_CHARACTERS='.,'

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question