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


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


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'
Scroll to Top