Change Oracle session to accept comma and dot number in C#

Question:

When opening a connection with oracle in C# , I need the . and the , behave according to the 0.000,00 rule in a real number. I would like to know how to change this format in the session opened in OracleConnection

Answer:

As per this article on the original OS, there are several answers that might clarify your problem: how-to-format-oraclenumber-generically

Here's one I liked:

alter session set NLS_NUMERIC_CHARACTERS='.,'
alter session set nls_date_format='YYYY-MM-DD HH24:MI:SS'
Post Views: 3
Scroll to Top