I have a bbdd in Oracle 12 with this parameter:
NLS_NUMERIC_CHARACTERS = '.,';
I would need it to be reversed ',.' . The only option I find is:
alter session set NLS_NUMERIC_CHARACTERS = ',.';
But this only changes it at the session level and I would need the bbdd to be in this format.
Could you help me? Thanks.
But this only changes it at the session level and I would need the bbdd be with this format.
The language parameters are regularly set at the client level, whose configuration ignores the server. The server stores the data in binary format (no separators are stored, that is, periods or commas). Recommended reading (in English): Format models
Having said that, you can set the default of the database in the initialization parameter file of your Oracle instance.
NLS_NUMERIC_CHARACTERS = ',.';
Although these are derived from the territory, so if your database is for a specific territory, it should be already well configured when initializing it, for example:
NLS_TERRITORY = 'GUATEMALA'
Complete list of territories and languages (for oracle 10g)
Finally, even if you do this, each client can choose their own format parameters, so none of this will be "mandatory", this is part of the Support for globalization of the database engine.